DSXchange

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

Hi,
What is the datatype and nullability of this column?

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?

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

thanks