You are not logged in.
I am fairly new to Talend and currently using "Talend Integration Suite - Enterprise Edition" Version: 3.1.4 Build id: r29781-20090916-0430
I have a job which is writing to a table using the tOracleSCD component. I have specified the fields that I want to be checked for changes as type 2.
At first all my rows were being duplicated with each run, even when there are no changes. I created a routine to check for nulls and empty strings and to set them to null. This routine is now applied to all the string values. Now only some of the rows are still being duplicated with each run.
Surely it is not normal to have to check each field for the SCD to work. Any ideas on what is going wrong and how to fix it?
Can you upload a screenshot of SCD editor?
The problem could be exist when you insert some value that are null, so you must put manualy null when
In this way the SCD should not update the record when there is not change.
I am facing a problem with tOracleSCD Component.
While Inserting new records I don't have any Problem but while updating the existing records then it got inserted into the table but with active flag = 0. The old and New records both have the active flag =1 which should not the New records should have active flag =1.
Please find the screen shot and let me know if there is any problems.
Awaiting your reply...
The Problem has been Solved. Thanks for your help and guidance.
It was due to in the map operation I had inserted extra columns perhaps.
Last edited by sit.sachin (2012-05-17 15:02:34)