I have created a simple job using Column Import stage to imports data from a single column and outputs it to one or more columns.
I used Sequential file to read data,Column Import Stage to import data from 1 column to multiple column and Target database.
But when i run the job it gives me an error:"Column_Import_1: The number of attached output data sets (1) differs from APT_Operator::setOutputDataSets() arg (2)."
Can somebody help me in resolving this issue.
Datastage Column Import Stage
Moderators: chulett, rschirm, roy
Datastage Column Import Stage
Nirmal Sharma
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray,
If we set Rejected Mode =Output then we need to keep a Reject file for that Reject Output. If we dont have reject file but the Mode set as Rejected Mode=Output then it shows the error messages as...
"Column_Import_1: The number of attached output data sets (1) differs from APT_Operator::setOutputDataSets() arg (2)"
Thanks,
Senthil P
If we set Rejected Mode =Output then we need to keep a Reject file for that Reject Output. If we dont have reject file but the Mode set as Rejected Mode=Output then it shows the error messages as...
"Column_Import_1: The number of attached output data sets (1) differs from APT_Operator::setOutputDataSets() arg (2)"
Thanks,
Senthil P
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: