The Data Replication Console does not allow the mapping of source tables or views that have certain characteristics unless you use the compatibility_checking_level parameter to override the default mapping validation behavior.
For DB2 for Linux, UNIX, and Windows sources, the following types of tables, views, and columns are not supported in table mappings:
Tables and Views
Columns
Temporary tables
Views
Columns that have unsupported datatypes
For Microsoft SQL Server sources, the following types of tables, views, and columns are not supported in table mappings:
Databases
Tables and Views
Columns
LOB/Backup compression
Database encryption
Temporary tables
System tables
Wide tables
Materialized and non-materialized views
Virtual computer columns
Columns that have unsupported datatypes
For MySQL sources, the following types of tables, views, and columns are not supported in table mappings:
Tables and Views
Columns
Temporary tables
Tables that include spatial datatypes such as GEOMETRY
Views
Columns that have unsupported datatypes
Identity columns
For Oracle sources, the following types of tables, views, and columns are not supported in table mappings:
Tables and Views
Columns
Clustered tables
Partitioned index-organized tables defined with both the OVERFLOW and INCLUDING clauses