Problem with merge Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rmmr
Participant
Posts: 6
Joined: Mon Sep 18, 2006 4:39 am

Problem with merge Stage

Post by rmmr »

We are using Merge stage(this stage is used no of datasets as inputs.Datasets contains data but it is not extracting while merging) in one of our jobs in version 7.5. while running the job it throws the following warning message.

WHEN CHECKING OPERATOR:DROPPING COMPONENTS"FIELD"BECAUSE OF PRIOR COMPONENT WITH THE SAME NAME.

All the fields are giving the same warning messages and finally it giving fatal error "creation of steps finished with failed".
madhukar
Participant
Posts: 86
Joined: Fri May 20, 2005 4:05 pm

Re: Problem with merge Stage

Post by madhukar »

Field names should be unique to get all columns from Master and Update Link. If there are too many similar column names then the warning mentioned by you occurs for every row processed and job gets aborted when warning limit exceeds.

One way is to switch off RCP in all output page of input to merge stage and in the output page of merge pull the column you want. Again define properly the Master Link and Update Link
Kirtikumar
Participant
Posts: 437
Joined: Fri Oct 15, 2004 6:13 am
Location: Pune, India

Post by Kirtikumar »

You can also rename the columns (except key col) that have same name on both links before they appear at modify stage.
Regards,
S. Kirtikumar.
Post Reply