Column headers are used to map the data in the CSV file to the correct locations in the staging area and target systems, and supports a number of different column types. The column type you select when defining the column header determines the appearance of the Column Header and Mapping dialog boxes that you use later in the import mapping process. Data Validator supports the following types of columns:
-
Physical - Maps to a specific column in the input data source.
-
Computed - Generates a new column using data from other columns or sources, such as environment type variables. This provides the ability to use functions. For example, you can enter a function in the Computed API box to replace original entries with new entries.
For more information, see Use the Computed column.
-
Constant - Allows you to use a string constant.
-
Prompted - Prompts the user for a value when a job is run, based on the job definition. The provided value is stored with the job definition for later use, if necessary.
-
Prompted API - Generates a list of prompts generated from other columns or sources, such as environment type variables, and displays this list using functions.
For more information, see Use the Prompted API column.
-
Prompted Picklist - Allows the user to pick an entry from a defined enumerated list in the local staging area when running a job.