You are not logged in.
I tried what you said. But it does not seem to be working for me.
It gives me the below error
"Cannot insert duplicate key row in object 'dbo.DG_CONTROL' with unique index"
Please find the screen shots attached. Please let me know what is wrong in my approach.
Thank you very much for the reply.
I am not very sure how to do that.
Could you please explain me with a simple example?
You could add a lookup(CONTROL) on your tmap and make an inner join on the eight column instead of defining these column as key. Then you catch the rejected rows and the matched ones.
I have the below scenario. Can you please suggest me how to go ahead with this.
I select values from PositionActivity Table and insert values to CONTROL Table after doing some enrichments.
1) The CONTROL table has a column "DATA_GRP_CTL_NUM" which is unique.
2) The CONTROL table also has some other eight columns as unique.
Part of the insert/update Logic is as follows.
if All the Eight columns are same then,
UPDATE CONTROL table values WHERE DATA_GRP_CTL_NUM = <existing DATA_GRP_CTL_NUM value>
In order to check whether the values are to be inserted or updated, i have specified all these eight columns as Keys in Talend, and it work fine.
But to update those rows, i want to update based on the DATA_GRP_CTL_NUM value.
I cannot add DATA_GRP_CTL_NUM column as Key. If I add, then Insert or Update logic of the talend will fail (as DATA_GRP_CTL_NUM will never be same for two rows).
Please find the image attached.