Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.
Success
Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMs
Customer Experience Accelerators
Accelerate your Purchase to Value by engaging with Informatica for Customer Success
My Engagements
All your Engagements at one place
 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
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Experience Lounge
Self-guided, intuitive experience platform for outcome-focused product capabilities and use cases
 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
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
SupportFlash
Monthly support newsletter
Product Availability Matrix
Product Availability Matrix statements of Informatica products
Product Lifecycle
End of Life statements of Informatica products
Pulse
Monitor the status of your Informatica services across regions
Events
Change Request Tracking
Marketplace
Trust Platform
English
  • Data Integration-Free and PayGo
  • All Products

Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations

Mappings

Mappings

Back Next

Step 2. Configure the source

Step 2. Configure the source

In this step, you create a Source transformation to specify the source object.
When you design a mapping, the first transformation you configure is the Source transformation. You select the source object in the Source transformation. The source object represents the source of the data that you want to use in the mapping.
Add the source object at the beginning of mapping design because the source properties can affect the downstream data. For example, you might filter data at the source, which affects the data that enters downstream transformations.
Use the CUSTOMERS table in the Oracle Mock Connector as the source object.
  1. On the mapping canvas, click the Source transformation to select it.
  2. In the Properties panel, click
    General
     and enter
    src_SampleCustomers
     for the Source transformation name.
  3. Enter the connection to use based on the source object. In this case, the source object is an Oracle table, so the connection needs to be an Oracle connection.
    Click
    Source
     and configure the following properties:
    Source detail
    Description
    Connection
    Connection to the sample Oracle data.
    Select the Oracle mock connection that you set up before you started the tutorial, Sample Oracle Connection (MockConnector).
    Source Type
    Source type, which can be an object or a parameter.
    Select
    Single Object
    .
    Object
    Source object for the mapping.
    Click
    Select
     and choose the CUSTOMERS table.
    If you want to view the data in the source file, click
    Preview Data
    .
    The following image shows the source details in the Properties panel:
    The Source tab of the Properties panel displays the selected source connection, type, and object for the source transformation.
  4. If you want to view the source fields and field metadata, click the
    Fields
     tab.
  5. To save the mapping and continue, click
    Save
    .
    The mapping will be marked "Invalid" at this point because you haven't configured the target yet.
0 COMMENTS
We’d like to hear from you!