When i tried to populate a dimension using incremental update and mapped a data base sequence to ROW_ID column in target for surrogate key i got the following error.
ORA-00904: "S"."ROW_ID":invalid identifier
Solution:
When i checked the IKM used for this mapping it is IKM Oracle Incremental Update change this to IKM SQL Incremental Update then the mapping it will work properly.
No comments:
Post a Comment