The data table and the status table are a part of the IBM® Product Master schema.
The data table (tldr_dat_data_table) and status
table (tldr_stt_status_table) are added to Product Master schema
to store the data generated from IBM InfoSphere® Information Server
and the status of the import respectively.
The tldr_dat_data_table table must
be populated with the data from IBM InfoSphere Information Server.
You must have a job in IBM InfoSphere Information Server
to do this, and tldr_stt_status_table table must
be populated with the status of the item import by the data loader
program. The clean up of these tables is beyond the scope of the loader
and you should do that regularly yourself.
The following rules
and restrictions apply to the columns and values of these tables:
Table 1. Data table
| Column name |
Column type |
Column length |
| JobID |
number |
9.0 |
| RecordID |
number |
9.0 |
| Name |
varchar2 |
256 |
| Value |
varchar2 |
256 |
Table 2. Status table
| Column name |
Column type |
Column length |
| JobID |
number |
9.0 |
| RecordID |
number |
9.0 |
| Satus |
varchar2 |
256 |
| Timestamp |
date |
|