You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tOracleSCD - inserting new row even when there are no changes
#1 2010-04-15 14:29:06
- lee
- New member
- Registered: 2010-04-15
- Posts: 2
tOracleSCD - inserting new row even when there are no changes
Hello,
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?
Many thanks.
Offline
#2 2010-04-16 05:54:32
Re: tOracleSCD - inserting new row even when there are no changes
Hello
Can you upload a screenshot of SCD editor?
Best regards
Shong
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#4 2010-04-30 09:51:25
- Ale
- Guest
Re: tOracleSCD - inserting new row even when there are no changes
The problem could be exist when you insert some value that are null, so you must put manualy null when
"".equals(row1.variable)?null:row1.variable
In this way the SCD should not update the record when there is not change.
Best regards.
#5 2012-05-16 09:45:15
- sit.sachin
- Member
- Registered: 2012-04-26
- Posts: 26
Re: tOracleSCD - inserting new row even when there are no changes
Hi,
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...
Thanks,
Sachin
Offline
#6 2012-05-17 15:02:05
- sit.sachin
- Member
- Registered: 2012-04-26
- Posts: 26
Re: tOracleSCD - inserting new row even when there are no changes
Hi Shicong,
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.
Thanks
Sachin
Last edited by sit.sachin (2012-05-17 15:02:34)
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tOracleSCD - inserting new row even when there are no changes