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?
Schema file related doubt
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Schema file related doubt
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore