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!

Slowly Changing Dimension in ODI 12c - How to handle deleted rows in the source table

User_2FGQOJan 21 2020 — edited Jan 21 2020

Dear All,

Some rows in my target tables are still flagged as 1/"Yes" as Current_flag, even they've been deleted in my Source table.

How can I solve this issue?

I'm currently using Slowly Changing Dimension as Integration Type.

In advance thank's for Your answers!

Olav

Added on Jan 21 2020

#business-intelligence-applications, #data-integrator, #system-management-and-integration

3 comments

1,601 views