	AllExperts > Peoplesoft
	Search

About Peter Choi
Expertise
I am a senior Oracle DBA, PeopleSoft Administrator and Project Manager with 10+ years experience. I have been working with PeopleSoft (HRMS 5, 7, 7.x and 8.x, 9.0), Oracle RDBMS (7.3 - 11gR1) on various Unix and Windows platforms, and some Oracle Application Server (9i/10g). I also have experience with the configuration and administration of BEA`s Tuxedo and WebLogic for PeopleSoft 8.x and 9.0.

You are here: Experts > Industry > IT Consulting > Peoplesoft > Dummy field in File Layout

Peoplesoft - Dummy field in File Layout

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

Add to this Answer Ask a Question