Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while Implementing Slowly Changing Dimensions

593270Dec 14 2007 — edited Jul 29 2009
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2009
Added on Dec 14 2007
5 comments
2,700 views