Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Glossary

Mapping Columns

Mapping Columns

For a direct connection, connect columns from the landing table to columns in the staging table. To cleanse the data coming from the landing table, add a function. The inputs to the function come from columns in the landing table. The output from the function goes to columns in the staging table.
This step assumes that you have the mapping open in the Diagram tab. If you used the Auto Mapping process, the columns with the same names are connected directly.
  1. In the
    Diagram
    workspace, review the connections that were created automatically. If any of the automatic connections are incorrect, delete the connections.
    1. Click the connector line.
    2. Right-click and select
      Delete Link
      .
  2. Decide if any of the unconnected columns in the landing table must be connected to columns in the staging table.
    When planning a connection, consider the following requirements:
    • Data types. The columns must have either the same data type or a data type that can be implicitly converted.
    • Cleansing. Do you want to cleanse the data or transform the data before loading it into the staging table? If so, you need to decide which function you want to use.
    • String length. In the staging table, columns with the CHAR or VARCHAR data types must have a length that is equal to or greater than the length for the column in the landing table.
      At load time, if a string is too long for the column in the staging table, the load process sends the entire record to the reject table.
  3. If data does not require cleansing, connect the columns directly. To connect the columns, from the landing table column, drag the output connector to the input connector on staging table column.
  4. If data requires cleansing, add a function to the workspace and then connect the columns.
    1. In the workspace, right-click and select
      Add Function
      .
    2. Select the function and click
      OK
      .
      The function appears in the Diagram workspace.
    3. Find the column in the landing table. Drag its output connector to the input connector on the function. Repeat to add additional columns as inputs to the function.
    4. From the function, drag its output connector to the input connector of the column in the staging table.
  5. After you finish adding connections, click
    Save
    .

0 COMMENTS

We’d like to hear from you!