HomeОбразованиеRelated VideosMore From: TechLake

ODI SCD Type 2 Implementation step by step process (Slowly Changing Dimension)

24 ratings | 12830 views
ODI SCD Type 2 Implementation step by step process, Oracle Data Integrator Interface example for implementing Slowly changing dimension Type 2. ODI 11g Tutorial ODI 11g Tutorial for beginners ODI Tutorial ODI Tutorial for beginners
Html code for embedding videos on your blog
Text Comments (8)
venkatesh Reddy (9 months ago)
Thank you very much for the detail explanation of SCD-TYPE2 implementation.
Antoaneta Vatova (1 year ago)
If end_date is 10-Jan-12, then next start_date is not 10-Jan-12, but 11-Jan-12. Otherwise the history is rubbish.
Sudheer Yella (2 years ago)
Hi Thank you for the helpful video. I want to change the default value for current_record_flag from 1 to 'Yes' . Where should I edit the KM? Can we edit the KM XML and re-import the KM?
Chhatar Singh (2 years ago)
Why are you defining SCD behavior for column one by one. It can be done on datastore attributes itself.
Skr Palazzi (2 years ago)
can you please tell me how? i can't find a way to do it faster
Ramesh Babu (3 years ago)
Thank you for this helpful video.. can you please tel that uses of variables and how it will work as project and global wise.
Diego Polanco (3 years ago)
Thanks very much... It was so helpfull...  I have a little question: How can I change the default date for end_date's column? I mean, when my row is 'active', I want to have a value of '2100/01/01' intead of the default '2400/01/01'. I hope you can help me, and thankyou again...
TechLake (3 years ago)
Edit your IKM Oracle Slowly Changing Dimension knowledge module and there you can find SCD_END default end_date value at below steps 222,292,302,322 and change this date=>  to_date ('01-01-2400', 'mm-dd-yyyy')","\nand\t","","SCD_END")%>

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.