Friday, March 29, 2013

SCD Type 2 error: ODI-1228:ORA-01747: invalid user.table.column, table.column, or column specification

ODI-1228: Caused By: java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification


This is common issue.

While enabling your SCD table column SCD properties if you not enable "Overwrite On Change" 
this property simply

Goto =>SCD IKM=>select Ignore error option on Update Existing Rows.

No comments:

Post a Comment