scd type2 creation

scd type2 creation

Hi.. I am working on Talend open studio 4.2.1.
can anybody explain me how to implement SCD type 2 concept in talend without using database SCD components for oracle plz..?
One Star

Re: scd type2 creation

Hi,
you can use Merge statement in tOracleImput component to implement SCD types logic on the tables.
Merge statement can do update, insert and delete in a single batch of query.
You can implement all types of SCD concepts using this Merge statement.
Refer this page for the Merge statement explanation and exmaples:
http://www.oracle-developer.net/display.php?id=203
One Star

Re: scd type2 creation

Follow the below link,and let me know if you could find anything more ?
http://www.talendforge.org/forum/viewtopic.php?id=20540