The following describe the steps for creating a Load table:
- Browse to the source system connection required (Browse > Source Tables).
- Double-click the Load Table object group in the left pane, the middle pane displays a list of existing Load tables.
- Click the source table from the right pane and drag it to the middle pane. You need to create the Load table with the required DSS columns—the option to add default metadata columns to the load table must be selected:
When the build table operation is performed, the Load table created has two additional columns that are populated by transformations:
- dss_record_source – the connection or source for the load table.
- dss_load_date – the date when the data was loaded to the table. This is updated every time a load operation is performed.
These DSS columns added, include column description and transformation information.
- Custom aliases for the dss_load_date and dss_record_source columns can be defined in the Tools > Options > DSS Tables and Columns > DSS Columns to Include and Naming window. If custom DSS aliases are defined, then the aliases are used for the column names that are added to the new Load tables. Refer to DSS Columns for details.
- The dss_record_source column transformation is set to the name of the source connection when the table is first created. If the source connection changes, the transformation value does not update automatically. You can manually update the transformation—refer to Transformations for details