DSXchange

Hi All,

how to capture unmatched records after doing reference with database .

could you please help this

Thanks in Adavance

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

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

only merge and lookup stage allow us to capture rejects

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.

Thanks Ray.

i will try with that.

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

I want to capture from Primary dataset(INPUT).

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

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