Lookup Clarification

poornima.chandramouli · Tue May 20, 2008 1:15 am

I was doing a lookup with 6 diffferent referernces.

I was getting a warning like ignorning duplicates in the lookup.

I want the duplicates to be propagated to the next level.

How to achieve this.

DSRajesh · Post by **DSRajesh** » Tue May 20, 2008 3:17 am

Do you mean that need to capture the duplicates or you want to use in the next stage?

devidotcom · Post by **devidotcom** » Tue May 20, 2008 3:24 am

You get this warning when your reference links have multiple matching records with input records. So DataStage randomly choose one of them and get the lookup value.

You can ignore this for only one of the reference links with an option on the condition tab of the lookup stage.

Devi

poornima.chandramouli · Tue May 20, 2008 4:57 am

devidotcom wrote:You get this warning when your reference links have multiple matching records with input records. So DataStage randomly choose one of them and get the lookup value.

You can ignore this for only one of the reference links with an option on the condition tab of the lookup stage.

Devi

All my reference links have duplicate entries(only my master is unique),i've to carry over all the dupliacte entries,becoz i'll be again joining the output with another dataset.

So how to carry over all these duplicates?

poornima.chandramouli · Tue May 20, 2008 4:58 am

DSRajesh wrote:Do you mean that need to capture the duplicates or you want to use in the next stage?

All my reference links have duplicate entries(only my master is unique),i've to carry over all the dupliacte entries,becoz i'll be again joining the output with another dataset.

So how to carry over all these duplicates?

ArndW · Post by **ArndW** » Tue May 20, 2008 5:08 am

In the lookup stage, get the details of the reference link and add the link name in the "multiple rows returned from link" drop down box. You can only do this for one link per lookup stage.