This diagram shows an example of the Conduits for Connect process using comma-separated value (CSV) files as the source.
In this example the process has three steps:
- You load data from your original databases into flat files created especially to hold data that you want to use in your Connect system. You can either use an extract script or manually write customer data from your data sources to one of three CSV files: Customer Master, Customer Subscription and Customer Attribute. See CSV Data File Specifications for further details.
- You use Informatica to load records from the CSV files into the Connect ETL staging tables.
- An Informatica post-session command automatically extracts data from the Connect ETL staging tables, transforms it using Informatica mappings, and loads it into the Connect tables. Phase 2 mappings (contained in the black box) validate the data from the Connect ETL staging tables and load records into the Connect database tables. Software developed the Phase 2 mappings and does not recommend or support any customer changes to these mappings.