Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Test Data Management H2L
  • All Products

Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Importing Flat File Sources in Test Data Management

Importing Flat File Sources in Test Data Management

Importing Flat File Sources in Test Data Management

Back Next

Create a Project and Import Flat File Sources in Test Data Manager

Create a Project and Import Flat File Sources in Test Data Manager

In Test Data Manager, create a project to store the TDM components. Import flat file metadata from the PowerCenter repository to the project to perform TDM operations on the source data.
  1. In Test Data Manager, click
    Projects
    .
    A list of projects appears.
  2. Click
    Actions
    New
    .
  3. In the
    Create Project
     dialog box, enter the following project properties:
    Name
    Enter a name for the project.
    Description
    Optional. Enter a description.
    PowerCenter Repository
    TDM populates the name of the PowerCenter repository to store the repository folder.
    Folder
    Default is the project name. You can choose another folder in the repository.
    Owner
    Default is the name of the user that created the project. You can select another user as the project owner.
  4. Click
    OK
    .
    The project opens in a separate tab.
  5. In the project, click
    Actions
    Import Metadata
    .
    The
    Import Metadata
     window appears.
  6. To import metadata from a flat file, select
    PowerCenter Repository
    .
  7. Choose to review the metadata changes before you import the metadata.
    Test Data Manager displays the information before the import runs.
  8. Click
    Next
    .
  9. Select the PowerCenter folder that contains the flat file source that you created in the Repository Manager.
  10. Click
    Next
    .
  11. Select the delimited and fixed-width flat files that you created in the PowerCenter repository.
    The following image shows the Import Metadata dialog box from where you can select the flat files:
    The Import Metadata dialog box shows that the flat files are selected.
  12. Click
    Next
    .
  13. To import the metadata immediately, choose
    Import Now
    .
  14. Click
    Finish
    .
0 COMMENTS
We’d like to hear from you!