Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Data Type Reference for Hadoop
  23. Glossary

TDM Source Definitions

TDM Source Definitions

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.