Import source metadata from the Model repository or directly from the source database to the TDM repository. The TDM project and the Model repository folders share the same name to ensure that the Data Integration Service stores workflow information in the correct Model 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 Model repository.
When you import source definitions from the Model repository into the TDM repository, you can import all the definitions supported by the Model repository. When you import source metadata from the Model repository, you import the Model repository folder that contains source metadata. Test Data Manager creates a copy of the folder in the TDM repository.
To use flat file sources, you must import flat files from 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.