Hi Techno's
Is it possible to have a single physical file for the mulitple reject links in a Parallel Job. If yes any limitations on its use ?
TIA
Akash
Can we have mulitple rejects pointing to same physical file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Fri Aug 13, 2004 3:36 am
- Location: INDIA
Hi Akash,
It is very much possible to have a single sequential file for multiple rejects using funnel.
But make sure that all the reject links have save same metadata and collect them in a funnel and pass them to the sequential file.
To identify the reject link from which the row is rejected (this is sometimes difficult since all the reject links have the same metadata) you can add a col generator stage between the reject link and the funnel. Add one column in the metadata (say 'RejectLink') and hard code the value using field properties of the column. Do this for each reject link.
So, after running the job if any rows are rejected, you can view the data in the sequential file and from the value in 'RejectLink' column you can identify from which link that record came.
Regards,
Srikanth Reddy
It is very much possible to have a single sequential file for multiple rejects using funnel.
But make sure that all the reject links have save same metadata and collect them in a funnel and pass them to the sequential file.
To identify the reject link from which the row is rejected (this is sometimes difficult since all the reject links have the same metadata) you can add a col generator stage between the reject link and the funnel. Add one column in the metadata (say 'RejectLink') and hard code the value using field properties of the column. Do this for each reject link.
So, after running the job if any rows are rejected, you can view the data in the sequential file and from the value in 'RejectLink' column you can identify from which link that record came.
Regards,
Srikanth Reddy