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