nerdexam
Oracle

1Z0-456 · Question #102

While reviewing the legacy data that was exported into a flat file, you realize that there is a certain field that contains irrelevant data. Which method describes how the field is handled during…

The correct answer is B. Select the ignore check box next to the field when you create the mapping. Source File Options Map each column that the source file is expected to contain with a specific attribute. The following table describes the details pertaining to columns provided in the source file: Source Column, Description The sequence number in which the columns are…

Oracle Fusion Applications Overview

Question

While reviewing the legacy data that was exported into a flat file, you realize that there is a certain field that contains irrelevant data. Which method describes how the field is handled during the import process?

Options

  • ACreate the custom field in Fusion and map the data to the field, but do not display the field in the
  • BSelect the ignore check box next to the field when you create the mapping.
  • CClick the Delete icon for the field when you create the mapping.
  • DOpen the flat file in a text editor, and manually delete the data in each row for the appropriate
  • EEnter a constant value for the field during the import process.

How the community answered

(25 responses)
  • A
    4% (1)
  • B
    84% (21)
  • C
    4% (1)
  • D
    8% (2)

Explanation

Source File Options Map each column that the source file is expected to contain with a specific attribute. The following table describes the details pertaining to columns provided in the source file: Source Column, Description The sequence number in which the columns are expected to be provided in the source file. Two rows cannot have the same sequence number. The column name expected in the source file if a header row is included, or more generic values such as Column A, Column B, and so on, if the header row is not included for Text file types. The tagging structure is represented for XML file types. Use when the delimiter value is fixed width for Text file types only. Ignore the source file column to exclude the data from being imported. If selected, a value must exist in the source file or the row will not be imported.

Topics

#data import#field mapping#import process#legacy data handling

Community Discussion

No community discussion yet for this question.

Full 1Z0-456 Practice