Schema file related doubt

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Schema file related doubt

Post by kandyshandy »

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?
Kandy
_________________
Try and Try again…You will succeed atlast!!
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

Thanks Ray 8)
Kandy
_________________
Try and Try again…You will succeed atlast!!
Post Reply