Error while Implementing Slowly Changing Dimensions
593270Dec 14 2007 — edited Jul 29 2009Hi All,
I am trying to implement the concept of Slowly Changing Dimension in the ODI.
I have Imported the Knowledge Module "IKM Oracle Slowly Changing Dimension"
and unchecked the option for "Journalizing table in the staging area" of Historize old rows.
For the Target Table i have set the OLAP type to "Slowly Changing Dimension" and the columns with surrogate key,natural key, etc...
When Executing the Interface i am getting error at the step "Updating existing rows".
When i looked into the query retrived at that time i could not find any columns in the SET Clause of the Update statement.
The SQL Query retrived at that time is like:
Update schema_name.table_name
Set(
)
select (
)
from I$_schema_name.table_name
.
.
.
Please can anyone help me...
Thank you in Advance