Unmatched records Capturing

nani0907 · Post by **nani0907** » Fri Nov 21, 2008 4:44 am

Hi All,

how to capture unmatched records after doing reference with database .

could you please help this

Thanks in Adavance

mdbatra · Post by **mdbatra** » Fri Nov 21, 2008 5:03 am

1.Left/Right/Full Outer in Join.
2. Use Reject Link from lookup.

nani0907 · Post by **nani0907** » Fri Nov 21, 2008 5:55 am

Is there any option without going for reject link in lookup stage .

hamzaqk · Post by **hamzaqk** » Fri Nov 21, 2008 5:57 am

only merge and lookup stage allow us to capture rejects

ray.wurlod · Post by **ray.wurlod** » Fri Nov 21, 2008 10:05 am

Only the Merge stage consumes rows as they are selected from its Update input(s). You could devise a mechanism to discover what remains in the Data Set supplying the Update input.

nani0907 · Post by **nani0907** » Sun Nov 23, 2008 10:45 pm

Thanks Ray.

i will try with that.

mdbatra · Post by **mdbatra** » Mon Nov 24, 2008 1:43 am

You want to capture unmacthed records from Primary(Input Data Set) or Secondary(Reference Data Set) ?

snt_ds · Post by **snt_ds** » Mon Nov 24, 2008 1:46 am

I want to capture from Primary dataset(INPUT).

mdbatra · Post by **mdbatra** » Mon Nov 24, 2008 2:01 am

snt_ds.
for capturing from primary ,have to use look up stage.

Shruthi · Post by **Shruthi** » Mon Nov 24, 2008 2:07 am

You can use joiner with join type as left outer join. Use left link as input.