Input Data for a Staging Table
The extract for a single table contains delimited data records. Depending on the conversion configuration, the CLOB data should be supplied either inline or in a separate, secondary file.
Input Data File Names
Input data file names has to follow the rules described in this chapter. The names are case-sensitive.
File Type |
File Name |
Single data file per table, no CLOB |
File name equal target table name, i.e. CI_PREM |
Single data file per table, single CLOB column in the table, CLOB data in secondary file |
Primary file name equal target table name, i.e. CI_PREM Secondary file name is composed as target table name concatenated with ‘_CLOB’, i.e. CI_PREM_CLOB |
Single data file per table, multiple CLOB columns in the table, CLOB data in secondary file |
Primary file name equal target table name, i.e. CI_PREM For each CLOB column being uploaded, the secondary file name is composed as target table name concatenated with CLOB column name concatenated with‘_CLOB’, i.e. CI_PREM_COL1_CLOB, CI_PREM_COL2_CLOB |
Multiple data files per table, no CLOB |
File name is composed as target table name concatenated with file number, i.e. CI_PREM1, CI_PREM2 etc |
Multiple data files per table, CLOB data in secondary file |
Primary file name is composed as target table name concatenated with numeric file number, i.e. CI_PREM1, CI_PREM2 etc Secondary file name is composed as target table name concatenated with ‘_CLOB’ and file number, i.e. CI_PREM_CLOB1, CI_PREM_CLOB2 etc |
Multiple data files per table, multiple CLOB columns in the table, CLOB data in secondary file |
Primary file name is composed as target table name concatenated with numeric file number, i.e. CI_PREM1, CI_PREM2 etc For each CLOB column being uploaded, the secondary file name is composed as target table name concatenated with CLOB column name concatenated with‘_CLOB’ and file number,, i.e. CI_PREM_COL1_CLOB1, CI_PREM_COL1_CLOB2, CI_PREM_COL2_CLOB1, CI_PREM_COL2_CLOB2 etc |