How to capture reject rows
Posted: Mon Dec 12, 2005 5:14 am
Hai All,
I have three sources and i need to compare these three sources and load in to my target.
My job design is for the first two sources i have used one joiner and compared it.for the last source i have used another joiner and put them in to a transformer, from transformer i have taken it to target which is my sequential file.My source is Terradata.
i have to use the condition PURE INNER JOIN and take the records out.every thing is fine and i got the result according to the condition.
out of 3lac records i have got 2lac records in the target, according to my condition.
Now i need to capture the rejected records.How can i achieve this.
Any suggestions, greatly appreciated.
Regards
Cherry
I have three sources and i need to compare these three sources and load in to my target.
My job design is for the first two sources i have used one joiner and compared it.for the last source i have used another joiner and put them in to a transformer, from transformer i have taken it to target which is my sequential file.My source is Terradata.
i have to use the condition PURE INNER JOIN and take the records out.every thing is fine and i got the result according to the condition.
out of 3lac records i have got 2lac records in the target, according to my condition.
Now i need to capture the rejected records.How can i achieve this.
Any suggestions, greatly appreciated.
Regards
Cherry