For data replication jobs, the target table structure must be compatible with the source table structure.
The source and target columns must have compatible datatypes. Also, Informatica recommends that the names of source tables and columns match the names of the target tables and columns.
In the Data Replication Console, you can perform the following tasks:
Generate target tables and audit log tables based on the source or target table schemas.
Generate SQL CREATE TABLE scripts that you can run later to create target tables and audit log tables based on the source or target table schemas.
If the source and target database types are different, Data Replication uses the rules in the <ConversionRules> section of the
DataReplication_installation
\uiconf\DataTypes.xml file to convert source column datatypes to compatible target column datatypes.
Data Replication does not generate target tables or audit log tables for