SQL & PL/SQL

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!

Implementing SCD 2 in PL/SQL

user10566312Nov 26 2011 — edited Nov 26 2011

Hi, please let me know if anyone has implemented Slowly Changing Dimension Type 2 using PL/SQL. If so could you please share the sample code. There are two scenarios:
1. What would be the code if from source we receive full extract.
2. What would be the code if from source we receive incremental data.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2011

Added on Nov 26 2011

5 comments

3,129 views