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: Informatica Platform Staging
  15. Appendix H: Informatica Platform Mapping Examples
  16. Appendix I: Glossary

Informatica Platform Mapping

Informatica Platform Mapping

Create a mapping in Informatica Developer (the Developer tool) that generates primary keys. The mapping must trim white spaces around the customer IDs and concatenate the values with the
|Billing
constant. Also, the mapping must add the
BILL
constant to the address type.
You set up the C_LD_LGC_CUSTOMER source data with the sample input data. Create a mapping with a physical data object, a mapplet, and a logical data object. The physical data object connects to the source data. The mapplet contains the transformation to generate primary keys. The logical data object writes to the staging table. You cleanse and move data directly from the source to the target staging table without the need for an ETL process.
The following image shows the mapping in the Developer tool:
A mapping, which contains a data source and a target staging table, and a mapplet that contains the Expression transformation.
The following image shows the mapplet that you use in the mapping in the Developer tool:
A mapplet, which contains an Expression transformation with expressions to trim and concatenate source data.
The mapping that you create contains the following objects:
Object Name
Description
Read_C_LD_LGC_CUSTOMER
The physical data object that you create to represent the data source.
Reads data from the data source.
C_SG_ LGC_PTY_BILL_ADDR_Mapplet
The mapplet that is created during the synchronization process.
You add the Expression transformation to the mapplet.
Exp_LGCPartytoBilingAddress
Expression transformation to cleanse and standardize data.
Contains the following ports:
  • CUST_ID. Pass-through port to pass customer IDs from the data source.
  • OP_CUST_ID_TRIMMED. Output port that returns customer IDs after it trims white spaces with the
    TRIMMEDCUSTID
    expression.
  • OP_PKEY_SRC_OBJECT. Output port that returns primary keys after it concatenates the |Billing constant to the customer ID with the
    CONCAT(TRIMMEDCUSTID,'|Billing')
    expression.
  • OP_BILLINGTYPE. Out put port that returns the BILL constant that is added to the address type output with the
    'BILL'
    expression.
  • TRIMMEDCUSTID. Variable port that returns the customer IDs after it trims the white spaces to the right and the left of the customer IDs with the
    LTRIM(RTRIM(CUST_ID))
    expression.
Write_C_SG_LGC_PTY_BILL_ADDR_LDO
The logical data object that is created during the synchronization process. Represents the target staging table, LGC Party to Billing Address Stg, and writes the cleansed and standardized data to the staging table.

0 COMMENTS

We’d like to hear from you!