DSXchange

Hi,

I have the requirement of loading the sequential file data into the data set.

But before tranformation of data , i have to check the input sequential file has the proper no. of columns, column sequence , proper column data type, mandatory data in a column.

In short, i have to validate my input sequential file with the meta data define for that sequential file.

How i will pre validate that sequential file in above context before actual data transformation with business validation on of data .

Guide me on above context which will help me to proceed in my job.

Thank you

is it delimited file or fixed width??

you can easily do this in a transform stage.

Sachin,

Also you can get the rejected rows from the Sequential file stage itself by selecting the option "Reject Mode=Output".


Balaji.

I wrote a routine which tries to resolve this issue. It is called KgdDebugMetadata. I hope you can find it. It was geared more to finding a bad column in line xxxx in the sequential file. I think you can modify it to meet your needs.