DSXchange

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?

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.

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: