DSXchange

Posted: **Thu Jan 17, 2013 3:54 pm**

I do have a lookup as

                                DB2 table
                                    |   | 
                                    |   |
----input data stream-->Lookup--target stream
                                     | 
                                     |
                                reject file

Also in lookup i specified conditions as
input.key1=db2table.key1 based on condition Flag = OUT
input.key2=db2table.key2 based on condition Flag = IN

in lookup constraints I specified action as

Code: Select all

condition 	condition not met	lokup on failure
---------	------------------	------------------
Flag = OUT      continue	continue
Flag = IN	      continue	continue

In director its showing warning as two times

lkp,0: Ignoring duplicate entry at table record 403958; no further warnings will be issued for this table

lkp,0: Ignoring duplicate entry at table record 403958; no further warnings will be issued for this table

1 does that mean it has two duplicate records?
And
2 how can i capcture those duplicate records in a file.
will reject file capcture duplicate records? OR rejected records OR both?

Posted: **Fri Jan 18, 2013 2:17 am**

Search the forum for Ignoring duplicate entry at table record

If the reference set is expected to have multiple records and you are expecting multiple lookup results , then enable return multiple rows in the lookup.

Else de duplicate the data using a remove duplicate stage.
If you have capture the duplicates then use sort stage with ke change column and redirecting rows with keychange as 0 to file.

Thanks,
Chetan.C

Posted: **Wed Jan 23, 2013 9:52 am**

thanks I used sort stage with key change column and redirecting rows with keychange as 0 to file.

this way i was able to see duplicate records in separate file

Posted: **Mon Jan 28, 2013 8:48 am**

qutesanju wrote:thanks I used sort stage with key change column and redirecting rows with keychange as 0 to file.

this way i was able to see duplicate records in separate file

Were you trying to do the lookup with the same data?

DSXchange

duplicate record at lookup

duplicate record at lookup