i got a job involve shared container and I just couldn't make is work...
this is part of my mail job:
![Image](http://i.imgur.com/ztvLX4w.jpg)
I enabled the RCP in the join stage (join mark)
![Image](http://i.imgur.com/b2dQ7y5.jpg)
this is the inside of my container
![Image](http://i.imgur.com/vnejGUo.jpg)
not all the columns from the main job passed into the container. i also enabled the RCP in the transformer stage in this job.
![Image](http://i.imgur.com/TDbtJAt.jpg)
![Image](http://i.imgur.com/NHvQ1VN.jpg)
this is how container stage's input tab and output tab setup:
input tab:
![Image](http://i.imgur.com/5WUv3L2.jpg)
output table:
![Image](http://i.imgur.com/eZlEAzI.jpg)
the transfermer stage (trans_fac_own) that after the container stage receive ALL the columns from join stage and one additional column created inside container
![Image](http://i.imgur.com/MxfqR32.jpg)
the job CAN compile and i receive the following error message when i run the job:
Code: Select all
Error when checking operator: Could not find input field "ENROLMENT_ID".
Error when checking operator: Could not find input field "STD_CRS_ID".
Error when checking operator: Could not find input field "SESSION_ID".
Error when checking operator: Could not find input field "BILLING_TYPE_SKEY".
...... (omit another 20 lines)
Code: Select all
Error when checking operator: When binding input schema variable "APT_TRinput0Rec0": A transfer adapter is dropping the non-existent field "FACULTY_OWN".
I reviewed the thread i posted long time ago, i did the same thing but i still cannot make it work
viewtopic.php?t=153295
does anyone know why?