To import a source file:
- Open the Start menu on your desktop and choose Programs > Informatica >
Designer.
- In the Designer window, select the Source Analyzer from the Tools section.
- From the Tool Bar, select the Sources tab, Import from File.
Source files may:
- Contain production or staging data
- Be relational databases or flat files
- Be stored in the Connect database or in another location
- Be in ETL table format or another format
Use the Informatica Designer’s Source Analyzer tool to import source data. Informatica’s
documentation explains how to use the Source Analyzer tool. See Informatica’s Getting
Started guide.
Note: The mapping process will be simpler if your source data is in the same format as the
ETL staging tables. The ETL staging tables are relational database tables stored in the
Connect database.