Informatica
-
Chapter 1
- Introduction and Architecture
- Introduction to Informatica
- Architecture of Informatica – Power Center
- Informatica Design Process
- Informatica Client Tool – Designer
- Source Analyzer and Warehouse Designer
- Mapping Designer
- Create a Simple Mapping
- Overview of Transformations
- Types of transformations – Active and Passive
- Expression Transformation
- Source Qualifier Transformation
- Introduction to Workflow Manager
- Task Developer
- Workflow Designer
- Creating Conections
- Flat Files Handling
- Create Simple Mappings
- Flat File Analysis
- Architecture Review
- Architecture 8.1 Review
- Differences between Power Mart and Power Center
- Create a Mapping
- Joiner Transformation
- Transformations
- Create a Mapping
- Using Join in a source Qualifier Transformation
- Expression Transformation
- Filter Transformation
- Transformations Contd
- Moltiple Target Loading
- Router Transformation
- Diff between Filter & Router Transformations
- Create a Mapping
- Master Outer Join
- Transformations Contd
- Create a Mapping
- Reusable Transformation
- Lookup Transformation
- Debugger
- Mapplets
- Create Mapplets
- Sequence Generator Transformation
- Moltiple Pipelines in a Single Mapping
- Target Load Plan
- Mapplets
- Update Strategy
- SCD Type 1 mapping Implementation
- Update Strategy Transformation
- SCD Type 2
- SCD Type 2 mapping Implentation
- Loading Strategy
- Sequential & Parallel Loading
- Union Transformation
- Dynamic Lookup Cache
- Introduction to Fact Loading
- Craete a Mapping
- Transformations Contd
- Create a Mapping
- Date Dimension Loading
- Lookup Transformation – Persistent Cache
- Aggregator Transformation
- Sorter Transformation
- Creating Stored Procedure
- Transformations Contd
- Stored Procedure Transformations
- Connected vs. Unconnected Transformations