topic scd type2 creation in Talend Studio

scd type2 creation

Anonymous — Sat, 16 Nov 2024 12:36:13 GMT

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..?

Re: scd type2 creation

karthikj18 — Wed, 11 Jan 2012 10:13:17 GMT

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

Re: scd type2 creation

Anonymous — Wed, 11 Jan 2012 11:24:49 GMT

Follow the below link,and let me know if you could find anything more ?
https://community.talend.com/t5/Design-and-Development/update-and-insert/td-p/110128