Using Views to Generate Audit Log Tables and Replicate Data to Teradata Targets
Using Views to Generate Audit Log Tables and Replicate Data to Teradata Targets
If you use Merge Apply mode with Teradata targets and have source tables with long column names, the Data Replication Console enables you to create views with shorter column names. You can then use the views to generate the audit log tables and to create mappings.
First generate a target table that has the same column names as the source tables. For the generated target table, create a view that includes the columns that correspond to the source columns but that have truncated column names. Generate the audit log table based on the view. Then map the source table to the corresponding view. You must perform all of these tasks in a single Data Replication Console session.
For example, a source table contains the TOTAL_NUMBER_OF_MEDICAL_CLAMPS column. You generate a target table with a column of the same name. You create a view for the target table that includes the column with the truncated name of TOTAL_NUMBER_OF_MEDICAL_C1. You generate an audit log table based on the view. The audit log table includes the TOTAL_NUMBER_OF_MEDICAL_C1_OLD and TOTAL_NUMBER_OF_MEDICAL_C1_NEW columns.
Generate the target table for the source table that has the long column names.