Page 1 of 1
Help with a lookup Logic
Posted: Wed May 18, 2011 7:39 am
by mac4rfree85
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!!!!
Posted: Wed May 18, 2011 8:03 am
by vinothkumar
Use Join stage with type as FULL OUTER.
Posted: Wed May 18, 2011 8:10 am
by mac4rfree85
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..
Posted: Wed May 18, 2011 9:56 am
by Mike
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
Re: Help with a lookup Logic
Posted: Thu May 19, 2011 8:58 am
by Sampath
use In lookup Multi link it will give all records from Primary and ref
Re: Help with a lookup Logic
Posted: Thu May 19, 2011 9:02 am
by Sampath
use In lookup Multi link it will give all records from Primary and ref
Re: Help with a lookup Logic
Posted: Thu May 19, 2011 9:02 am
by Sampath
use In lookup Multi link it will give all records from Primary and ref
Posted: Thu May 19, 2011 4:57 pm
by ray.wurlod
Full outer join. Transformer or Filter with three outputs testing whether stream key is null, reference key is null or neither is null.