main_program: Fatal Error: Destination "leftRec.leftRec_EmployeeReconId" is already bound.
does anybody have any idea what does this mean?
I am using this as key in full outer join
full-outerjoin using
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
What is the datatype and nullability of this column?
What is the datatype and nullability of this column?
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Hi,
its is notnull and varchar.
To give little history wt ia m doing, i have this two bills i am comapring , Prior Vs current,
In would be nending to go aand get the employeereconid added in current bill, dropped from prior bill. i ahve joined the two sqls on employee reconid and in trnasormer based on constaraints iam separating added and terminated, for the rest "emprecids" on both bills, i ll have to now cehck for their "certs" additions and termonations, so again ia m doing fullouter, with emprecid(Previously done) and certs? so doing fullouter twice on same field matter?
its is notnull and varchar.
To give little history wt ia m doing, i have this two bills i am comapring , Prior Vs current,
In would be nending to go aand get the employeereconid added in current bill, dropped from prior bill. i ahve joined the two sqls on employee reconid and in trnasormer based on constaraints iam separating added and terminated, for the rest "emprecids" on both bills, i ll have to now cehck for their "certs" additions and termonations, so again ia m doing fullouter, with emprecid(Previously done) and certs? so doing fullouter twice on same field matter?
sameer
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
I didnt get your explanation clearly but i dont think full outer join on same filed matters.
Just search your error in this forum,you will get multiple result.For your reference i am giving you below link:-
viewtopic.php?t=127756&highlight=already+bound
I didnt get your explanation clearly but i dont think full outer join on same filed matters.
Just search your error in this forum,you will get multiple result.For your reference i am giving you below link:-
viewtopic.php?t=127756&highlight=already+bound
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/