DSXchange

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.

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.