When I run the job, target table has loaded 102 records after that due to some problems job has been failed or Aborted. After solving the problem I want the to load the data from 103 record onwards (I dont want to load from 1st record).
Short answer is "skip them". However - static source? Meaning when you rerun it, will the 103rd record in the second run be the same 103rd record from the first run?
-craig
"You can never have too many knives" -- Logan Nine Fingers
Not a quick solution - you may try comparing the loaded records against the source and eliminate them. If upsert option does not work for you, have you tried using a transaction size of 0?
You "skip" them using a constraint in a transformer (@INROWNUM > X) but there's a lot more to it than that in the PX environment. And only you can say if it will "give good result" if you do that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Yes/no/maybe. Remember that each Transformer stage instance (there are four if you are running in a four node configuration) keeps its own, separate, count.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.