You are receiving a FIXED formatted file from an outside vendor. You want to import the file data into your PeopleSoft system. However, the description field on the file has commas inserted and you want to eliminate them before populating your system tables. Which are the five steps you need to perform to create the file layout on your system to import the data and eliminate the extraneous characters in a field? (Choose five.)
A. Write the application engine program to export the data.
B. Provide the import data in a correctly formatted flat file.
C. Create a file layout to match the record and field structure of the data.
D. Set the file layout properties to specify the file layout format of FIXED.
E. On the Preview tab, enter a comma as the strip character on the description field.
F. Set the File Record ID on the File Layout segment properties.
G. Preview and troubleshoot the input data format and content.
H. On the Preview tab, enter a comma as the field qualifier on the description field.
|
Download Printable PDF. VALID exam to help you PASS. |
 |