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
  • Informatica Data Quality H2L
  • All Products

Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Creating a Column Profile on a Logical Data Object in Informatica Developer

Creating a Column Profile on a Logical Data Object in Informatica Developer

Creating a Column Profile on a Logical Data Object in Informatica Developer

Back Next

Creating a Joiner Transformation and Viewing the Transformation Results

Creating a Joiner Transformation and Viewing the Transformation Results

You can create a Joiner transformation to view all the customers residing in a particular ZIP code location. You must connect the ports from the physical data objects to the Joiner transformation, and connect the ports from the Joiner transformation to the logical data object. You can view the Joiner transformation results in the
Data Viewer
 view.
  1. In the
    Object Explorer
     view, select the
    Customer_LDO
     data object, and click
    Read Mapping
     tab.
    The
    Read Mapping
     view appears.
  2. In the
    Read Mapping
     canvas, drag and drop the
    Customer_IB
     physical data object.
    The
    Add to Mapping
     dialog box appears.
    The following image shows the
    Add to Mapping
     dialog box:
    The image shows the add to mapping dialog box.
  3. In the
    Add to Mapping
     dialog box, select
    Read
    , and click
    OK
    .
    The
    Customer_IB
     physical data object appears in the
    Read Mapping
     tab.
  4. Similarly, drag and drop the
    Customer_NB
     physical data object into the
    Read Mapping
     tab.
    The following image shows the
    Customer_IB
    ,
    Customer_NB
    ,
    Customer_LDO
     data objects in the
    Read Mapping
     tab.
    The image shows the physical data objects and logical data objects in read mapping tab.
  5. In the
    Read Mapping
     tab, click
    Joiner
     transformation.
  6. Drag the
    Lastname
    ,
    Firstname
    , and
    ZIP
     in the
    Read_Customers_IB
     to
    Master
     in the
    Joiner
    . Similarly, drag the
    Lastname
    ,
    Firstname
    , and
    ZIP
     in the
    Read_Customers_NB
     to
    Detail
     in the
    Joiner
     transformation.
  7. Click
    Joiner
     transformation, and click
    Join
     in
    Properties
     view.
  8. Enter the join condition as
    ZIP=ZIP1
    .
    The following image shows the
    Properties
     view for the
    Joiner
     transformation with the join condition:
    The image shows the properties view for the joiner transformation.
  9. Drag the
    Lastname
    ,
    Firstname
    ,
    Lastname1
    , and
    Firstname1
     ports to the
    Customer_LDO
     data object.
    The following image shows the Joiner transformation and the logical data object in the
    Read Mapping
     tab:
    The image shows the joiner transformation and logica data object.
  10. Right-click the Joiner transformation, and click
    Run Data Viewer
     to preview data.
    Informatica Developer displays the data in the
    Output
     section of the
    Data Viewer
     view. The
    Output
    section shows the combined data from the
    Read_Customers_IB
     source and
    Read_Customers_NB
     source.
    The following image shows the results for the join condition in the
    Data Viewer
     view:
    The image shows the results for the join condition in the logical data object.
0 COMMENTS
We’d like to hear from you!