Expert: Peter Choi - 9/21/2009

Question
I have an input file with 50 fields, and I only need to read 4 fields. How do I set the 46 fields as dummy, so that the layout remains the same but only the 4 fields are read? The input file is in CSV format. Thanks in advance.

Answer
Hi Tejas,


To be able to make use of the PeopleCode that may be invoked when you are processing your flat file, you will need to create your layout to match the data that you intend on loading. You can always expand on the file layout as the number of fields grow (say beyond your initial 4 fields).

Reference: http://download.oracle.com/docs/cd/E13292_01/pt849pbr0/eng/psbooks/tapd/book.htm...

Hope this helps.

Peter