DSXchange

Can anyone explain me the below question.

What all the possible reasons, a sequential file stage will reject data to a reject link.

Suppose I have 4 columns as below

Col1 varchar Not Null,
Col2 varchar Null,
Col3 varchar Not Null
Col4 varchar Null

Is this an interview question?

As a general rule strings are never rejected.

But you have not provided any information about Null Field Value property or the data values in the file, so a complete answer is clearly impossible.

Thanks Ray.

This is not a interview question. I did a search in help and I could not find any details on the reasons of the rejects in a sequentila file stage, so I posted in the forum.

I have a requirement to read a sequential file ( csv file ) and load into target file.

As per the metadata of the csv file, for the Null values, the I have set the Null field value property to handle the nulls.

Other than this, what are the possible rejects of the stage.

Only one that I can imagine - reading a null (null field value) for Col1 or Col3 where there is no default value defined.