Hi,,
I am using merge stage to merge the counts coming from 5 aggregator stages and one oracle enterprice dependint on 5 key columns. the 5 key columns are common ..comming from all aggregator stages and the oracle enterprise.
But when i run the job...even if the data is able to be viewed from oracle enterprice
the Director gives the following warning
STG_MRG_10,0: Update record (0) of data set 6 is dropped; no masters are left.
And the record from oracle enterprise is giving a NULL value from Merge stage.
Please suggest.
STG_MRG_10,0: Update record (0) of data set 6 is dropped;
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
As each "lookup" is performed in a Merge stage, the secondary record is consumed. This is documented behaviour and might be one of the reasons for using this stage type, to perform true master/update comparisons.
That is why de-duplicated inputs are recommended.
Sounds like you want a Lookup stage rather than a Merge stage.
That is why de-duplicated inputs are recommended.
Sounds like you want a Lookup stage rather than a Merge stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.