1. Does the input data contain duplicate key values?
A- looking based on primary keys
2. What alternative do you plan for detecting change when the row already exists in the target table? ..
A-If the row exists with same key then i just want to update few columns in target table, thats it.
What I was getting at in the first question is what happens if the same key arrives twice in the stream of input data? How do you need to play this?
You can only insert the first of them.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Loaded in an earlier job, RefDS contains keys and those columns from the target that you wish to compare. The Lookup stage "lookup failed" rule is Continue. The Transformer stage directs failed lookups to the insert link and detects changes (by direct comparison) where the lookup was successful.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Techincally, you've got 20,000+ people who could help you out here, however the vast majority only seem to post when they have a problem. It's a very small group that try to help others, but that's the way it is anywhere, the nature of the beast. And when the Alpha Male steps in, almost everyone else steps back from the kill and lets him have his fill.
Or maybe no-one else is silly enough to work weekends.
Last edited by chulett on Sun Sep 07, 2008 5:50 pm, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
There are only five premium posters, one of whom is currently sailing (or riding out storms) in the Caribbean. Anyone else with constructive thoughts on any issue is welcome to post, but it's their choice whether they do or not.
Anyway, don't you have an official support provider?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.