Hi all,
HI have a job in which there are two source datasets and i m trying to join these datasets based on three columns(mkt code,sale date and mob_no) and join conditionm is full outer. But when i am running a job it get abored and gives an error message
main_program: Fatal Error: Destination "leftRec.leftRec_MKT_CODE" is already bound.
Can anyone help me to resolve this issue?
Thanks
error:-........ is already bound
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
My guess - you have identically-named columns on both inputs and the result of the join - you have not provided separate output columns into which to map the left and right input columns.
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.
To add to what Ray has already said, another possibility is that you have runtime column propagation turned on and don't directly "see" the duplicated column name becuase it has been passed in from a previous stage.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>