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

Parent topic

Input Data Files