This discussion is archived
1 Reply Latest reply: Jan 22, 2010 3:18 AM by Christian Berg RSS

SIL_ListOfValuesDimension does not capture changes

747404 Newbie
Currently Being Moderated
Hello

I have issues with the mapping SIL_ListOfValuesDimension - it seems not to process updated records, but only to insert new records. Hence whenever we e.g. change the DESC_TEXT or LOW value of an LOV record, it is not updated to W_LOV_D.

Reason is, that the mapping applies a filter ISNULL(LKP_ROW_WID). Exact porcess is

- Lookup on W_LOV_D - condition on VAL, TYPE and NAME. Return ROW_WID
- Filter: ISNULL(LKP_ROW_WID)
- Another Lookup on W_LOV_D - condition only on TYPE AND NAME. Return ROW_WID

I am now planning to change this filter to make it process also existing records and pass updates - however I am worried that this might have side-impacts - since I do not fully understand the background and reason for the abvoe procedure with the 2 consecutive lookups.

Any experience with this issue? Any recommendations how to proceed?

Edited by: user4594204 on Jan 19, 2010 12:12 AM

Edited by: user4594204 on Jan 19, 2010 12:12 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points