Load unmatched data

swades · Post by **swades** » Wed Jan 31, 2007 5:51 pm

Hi,
I want to get Unmtched data to be load in Target Table. I am comparing source record with the Target Table.

How can I do this with Merge Stage ?

Thanks

swades · Post by **swades** » Wed Jan 31, 2007 6:04 pm

Continue to above Post:

Or can I use look up stage ?
Please help me how ?
what to set in constraints. I have try that BUT I am failed. I am using 7.5.2

Thanks

DSguru2B · Post by **DSguru2B** » Wed Jan 31, 2007 6:24 pm

You can do it with the Join or lookup stage. Read about those stage on the exact way on "how to do it"

swades · Post by **swades** » Wed Jan 31, 2007 7:18 pm

Thanks
I have try a lot using look up but still I am getting matched data only in Target Table so please tell me if any Condition is required in lookup stage to get unmatch data in Target Table ?

Please help me if possible because I have not used Look up stage before to get Unmatched data

Thanks

DSguru2B · Post by **DSguru2B** » Wed Jan 31, 2007 7:50 pm

Refer to Ray's first reply in this post.

swades · Post by **swades** » Wed Jan 31, 2007 10:31 pm

Thanks DSguru2B,

I read that Post but It didnt help me.
Here is the detail what I am doing:
I am gettig recored from flat file and I am looking this record to the Target table and If Data matches then I want to reject and If not matching then I am inserting this recored to Target Table.
I tried Lookup but its not loading unmatched data to table, might be I am doing wrong.

Plesase help me

Thanks

swades · Post by **swades** » Wed Jan 31, 2007 11:14 pm

ray.wurlod · Post by **ray.wurlod** » Wed Jan 31, 2007 11:21 pm

You can use a lookup stage, specify a reject link to capture the unmatched inputs and set your Lookup Failed rule accordingly.

You could also use a right outer join; the rows with NULL from the left inputs are unmatched rows in the target.

venky · Post by **venky** » Thu Feb 01, 2007 12:55 am

if you wish to use the same design , then use a transformer from the rejected link and load the data to a target table.
Else u can use continue option in lookup stage and out a transformer and check for null keys and load to target table ( these are unmatched records )

Ashish · Post by **Ashish** » Thu Feb 01, 2007 1:49 am

In Lookup stage There is one property If Not Found = Output you can retrive all your unmatched data in the reject link and passed it to the Target Table

Thanks
Ashish Arora[/img]

kumar_s · Post by **kumar_s** » Thu Feb 01, 2007 5:00 am

ChangeCapture/Difference stages are also available for this reason.

DSguru2B · Post by **DSguru2B** » Thu Feb 01, 2007 8:14 am

swades wrote:How can I do this with Merge Stage ?

You asked for it to be done in Merge stage, you got expert advice on so many stages that can get your work done.

DSXchange

Load unmatched data

Load unmatched data

Re: Load unmatched data

Re: Load unmatched data