Finding Record processed status
Posted: Mon Dec 17, 2007 3:39 am
I have 10 records in input file.
I extracted using sequential file stage and kept into another sequential file stage.
I want to find the Record Status for all records.
for ex, if a record is processed with Warnings it should be flagged as 'W'
if a record is processed with Errors then it should be flagged as 'E'
if a record is processed successfully then it should be flagged as 'N'.
How to perform this process in datastage server eddition?
how to get the solution can any explain this?
Regards..
I extracted using sequential file stage and kept into another sequential file stage.
I want to find the Record Status for all records.
for ex, if a record is processed with Warnings it should be flagged as 'W'
if a record is processed with Errors then it should be flagged as 'E'
if a record is processed successfully then it should be flagged as 'N'.
How to perform this process in datastage server eddition?
how to get the solution can any explain this?
Regards..