DSXchange

A job that reads from a sequential file, applies some business logic, and writes the results to a db. Layout of input file change from run to run. All columns will remain the same, but the order of them will change. which feature of sequential file stage allows to accomplish this?

Answer: Schema file.

Are they asking about automatic handling of differences in the order of the column or manual handling of differences in column? If automatic, then there needs to be a way to specify "first line is column names" in schema? Your comments?

They are asking about differences in the order of the columns.

Exam technique tip: Don't read anything into the question that isn't there.

Thanks Ray