Table of Contents

Search

  1. Introduction
  2. Configuring Hub Console Tools
  3. Building the Data Model
  4. Configuring the Data Flow
  5. Executing Informatica MDM Hub Processes
  6. Configuring Application Access
  7. MDM Hub Properties
  8. Viewing Configuration Details
  9. Search with Solr
  10. Row-level Locking
  11. MDM Hub Logging
  12. Table Partitioning
  13. Collecting MDM Environment Information with the Product Usage Toolkit
  14. Glossary

Input Data Sample

Input Data Sample

The input data set contains source data such as customer ID, name, and address details for each customer.
For Informatica platform staging, use the sample input data to create a data source that you can connect to from Informatica Developer (the Developer tool). You add the data source to the mapping in the Developer tool as a physical data object.
For the MDM Hub staging, before you create the mapping, you load the sample input data from the data source into the landing table. You use an ETL process to load data into the landing table.
The following data extract shows a sample of the source customer data:
CUST_NAME
CUST_ID
BILL_ADDR_LN1
BILL_ADDR_STATE
BILL_ADDR_TYPE
CBS
SLS2051
4217 COLBY AVE SW, WYOMING
MI
B
CITIFINANCIAL
SLS2052
32525 BRIARWOOD DR, RIDGEVILLE
OH
B
RAKE CHARLES
SLS2053
590 N 24TH AVE E, ADOLPH
MN
B
RUBI SAEED
SLS2054
519 S QUEENS RD, ROCHELLE
IL
B
AHMED RAUF
SLS2055
7610 ROSENWALD LN, NOKESVILLE
VA
B
JEFF RIBBON
SLS2056
46 ATLANTA ST, LUMBERTON
NC
B
YIN HUN IAN PUN
SLS2000
2958 RIPLEY RD, EUCLID
OH
B

0 COMMENTS

We’d like to hear from you!