Data Stage Server job- Capturing rejected records

ksudhir466 · Post by **ksudhir466** » Fri Jun 19, 2009 1:44 am

Hi,
I am using Sequentuial file stage in server job. I need to capture all the records which are not matched with metadata ( data format such datatype, fixedlength property etc). after capturing all records the job should get abort.
Can anyone pls suggest , Is it possible in server job?

ArndW · Post by **ArndW** » Fri Jun 19, 2009 1:58 am

It is possible to do, but you will need to use a transform stage and write explicit checks on each column since server jobs are not strictly typed as they are in PX jobs.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 19, 2009 11:06 pm

Welcome aboard.

In addition to what Arnd posted, I would recommend that you create re-usable components (Routines or Transforms) for particular checks.

For example to check for signed integer:

Code: Select all

%Arg1% Matches "1N0N" : @VM : "'-'1N0N" : @VM : "'+'1N0N"