While loading PowerCenter sessions into the Metadata Manager warehouse, Metadata Manager rejects or filters the records if it cannot resolve their corresponding database columns.
Metadata Manager filters records that meet any of the following conditions:
The session instance connection is not assigned to a database schema.
The connection assignment is valid, Metadata Manager cannot resolve the database column, and an SQL override exists on the reader transformation, such as Lookup or Source Qualifier transformation.
Metadata Manager rejects records that meet any of the following conditions:
The session instance connection is assigned to a schema, the Source Qualifier transformation does not have an SQL override, and Metadata Manager cannot resolve the database columns.
Metadata Manager cannot resolve the PowerCenter target structure and the corresponding database columns.