You can import source metadata directly from the source if the source is a relational database. If the source contains many tables, you can increase the performance if you import the metadata directly from the source instead of from PowerCenter.
When you import source definitions from the PowerCenter repository into the TDM repository, you can import all the definitions supported by PowerCenter. When you import source metadata from PowerCenter, you import the PowerCenter folder that contains source metadata. Test Data Manager creates a copy of the folder in the TDM repository.
When you import the MongoDB sources to PowerCenter, you must ensure that the column names are unique and does not contain more than 80 characters in a column name.
To use flat file sources, you must import flat files from the PowerCenter repository. You cannot create flat file connections in Test Data Manager.
Rowid is a reserved keyword. You cannot import Oracle sources that have rowid as a column name or a table name.