Using Informatica

This chapter describes how to do data integration using the Informatica-based Toolkit.

Before You Begin
The Repository
Backup and Restore
Security: Users and Folders
Locks
Using the Mapping Designer
Ports
Transformations
Source Files
Staging Tables
Target Tables
Database Connections
Server Configuration
Sessions and Batches
Loading Data
Pre- and Post-Session Commands
Job Control
File Wait
E-mail Notification
Using Databases as Sources
Overview: Using Databases as Sources
General Rules for Integration
Using Flat Files as Sources
Overview: Using Flat Files as Sources
General Rules for Integration
Key Concepts for Using Flat Files
Preliminary Steps
The ETL Process
Phase 1: Moving Data from Source Files to Staging Tables
Phase 2: Moving Data from Staging Tables to the Connect Tables
Advanced Integrations