Help with a lookup Logic

mac4rfree85 · Post by **mac4rfree85** » Wed May 18, 2011 7:39 am

Hi Guys,

I want to create three datasets from lookup.
Dataset1. Records present in primary and not in Reference.
Dataset2. Records present in both primary and Reference.
Dataset3. Records present in Reference and not in primary.

Can somebody help me with this.

Cheers!!!!

vinothkumar · Post by **vinothkumar** » Wed May 18, 2011 8:03 am

Use Join stage with type as FULL OUTER.

mac4rfree85 · Post by **mac4rfree85** » Wed May 18, 2011 8:10 am

Actually i need three datasets and not all the recrods in one dataset.
I have modified my intial post..

The Change capture stage should be able to get this results,, am just guessing need to work on it..

Mike · Post by **Mike** » Wed May 18, 2011 9:56 am

Join stage (full outer) and change capture stage are both suitable. Both stages will produce 1 virtual dataset as output which you'll have to divide into 3 datasets using another stage (e.g. transformer).

Mike

Sampath · Post by **Sampath** » Thu May 19, 2011 8:58 am

use In lookup Multi link it will give all records from Primary and ref

Sampath · Post by **Sampath** » Thu May 19, 2011 9:02 am

use In lookup Multi link it will give all records from Primary and ref

Sampath · Post by **Sampath** » Thu May 19, 2011 9:02 am

use In lookup Multi link it will give all records from Primary and ref

ray.wurlod · Post by **ray.wurlod** » Thu May 19, 2011 4:57 pm

Full outer join. Transformer or Filter with three outputs testing whether stream key is null, reference key is null or neither is null.

DSXchange

Help with a lookup Logic

Help with a lookup Logic

Re: Help with a lookup Logic

Re: Help with a lookup Logic

Re: Help with a lookup Logic