ODI 11g Error:ORA-00920 in SCD Type 2 Solved.

ODI Error: ORA-00920 invalid relational operator.

Check the code corresponding to the interface and you can see an extra "and" condition after "where" clause.

Solution:

When implementing SCD Type 2 we define slowly changing dimension behavior for  each column in the table.

now i have given overwrite on change to all columns other than

• Natural key
• Surrogate key
• Current record flag
• Starting time stamp
• Ending time stamp

If we are using IKM for slowly changing dimension we have to give Add Row on Change for  at least one column else if we are using Over Write on change for all column there is no meaning in using IKM for slowly changing dimension we can meet that with IKM for incremental update.