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.
Lookup Clarification
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Wed Dec 26, 2007 1:58 am
- Location: India
Lookup Clarification
Regards
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
-
- Participant
- Posts: 42
- Joined: Wed Dec 26, 2007 1:58 am
- Location: India
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.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
So how to carry over all these duplicates?
Regards
-
- Participant
- Posts: 42
- Joined: Wed Dec 26, 2007 1:58 am
- Location: India
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.DSRajesh wrote:Do you mean that need to capture the duplicates or you want to use in the next stage?
So how to carry over all these duplicates?
Regards