Capturing Rejected data columns in to reject file using RCP
Moderators: chulett, rschirm, roy
Capturing Rejected data columns in to reject file using RCP
I am using generic job to extract a table and load the same table in another schema using RCP enabled in the job. The target connector ( oracle) has a reject link with ERROR CODE and ERROR TEXT columns selected.
When I ran the job and there were rejects, I could only see ERROR CODE and ERROR TEXT in the reject file. I would like to see the actual record to take corrective action.
Please suggest how do I design the job to be able to see actual record ( actual columns along with ERROR CODE and ERROR TEXT).
When I ran the job and there were rejects, I could only see ERROR CODE and ERROR TEXT in the reject file. I would like to see the actual record to take corrective action.
Please suggest how do I design the job to be able to see actual record ( actual columns along with ERROR CODE and ERROR TEXT).
-
- Participant
- Posts: 58
- Joined: Mon Dec 14, 2015 3:16 pm
- Location: Arizona
I went and did view data on the reject file. Since there are only ERRORTEXT and ERRORCODE columns in the metadata so i am able to view only these two columns. I also went and checked the file in the unix path manually and the file also doesnt have other columns except the above two.Mike wrote:How did you look at your reject file?
This is a generic job and I dont know the what columns will come for a table. That is the reason to go with RCP instead of mapping columns. I have to use same job to load multiple tables.anudeepdasari001 wrote:Try checking with Disabling RCP and Map all the columns till the Target connector,Then you can check the columns list on the oracle connector output tab for reject link.
Re: Capturing Rejected data columns in to reject file using
Can anyone please respond to this post. I am stuck with jobs development due to this issue. Any help is appreciated