Import source metadata from PowerCenter, the Model repository, or directly from the source database to the TDM repository. The TDM project and the repository folders share the same name to ensure that the service stores workflow information in the correct repository folder.
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 or the Model repository.
When you import source definitions from the PowerCenter repository or the Model repository into the TDM repository, you can import all the definitions supported by Informatica service. When you import source metadata from the repository, you import the repository 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 or the Model 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.