[go: up one dir, main page]
Scribd
Upload
113 views3 pages

Informatica Topics

The document discusses Informatica 8.1.1 and covers topics like architecture, transformations, mapping design, loading strategies, and workflow tasks. It includes 18 chapters that provide details on creating mappings, different transformation types, flat file handling, SCD types, incremental loading, and more. Case studies are also presented to demonstrate concepts.

Uploaded by

ashrith_kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
113 views3 pages

Informatica Topics

The document discusses Informatica 8.1.1 and covers topics like architecture, transformations, mapping design, loading strategies, and workflow tasks. It includes 18 chapters that provide details on creating mappings, different transformation types, flat file handling, SCD types, incremental loading, and more. Case studies are also presented to demonstrate concepts.

Uploaded by

ashrith_kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

INFORMATICA 8.1.

1 WITH CASE STUDY



Chapter 1 -- Introduction and Architecture

-Introduction to Informatica
- Architecture of Informatica -- PowerCenter 8.1
- Informatica Design Process
- Informatica Client Tool -- Designer
- Source Analyzer and Warehouse Designer

Chapter 2 - 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 Connections

Chapter 3 -- Flat Files Handling
- Create Simple Mappings
- Flat File Analysis

Chapter 4 -- Architecture Review
- Architecture 8.1 Review
- Differences between PowerMart and PowerCenter
- Connecting to SAP
- FTP Process
- Command Task
- Create a Mapping
- Joiner Transformation

Chapter 5 -- Transformations
- Create a Mapping
- Using Join in a Source Qualifier Transformation
- Expression Transformation
- Filter Transformation


Chapter 6 -- Transformations Contd
- Multiple Targets Loading
- Router Transformation
- Diff Between Filter and Router Transformations
- Create a Mapping
- Master Outer Join

Chapter 7 -- Transformations Contd
- Create a Mapping
- Reusable Transformation
- Lookup Transformation
- Debugger
- Handling Multiple Files as Source

Chapter 8 -- Mapplets
- Create Mappings
- Sequence Generator Transformation
- Multiple Pipelines in a Single Mapping
- Target Load Plan
- Mapplets

Chapter 9 -- Update Strategy
- SCD Type 1 mapping Implementation
- Update Strategy Transformation


Chapter 10 -- SCD Type 2
- SCD Type 2 mapping Implementation

Chapter 11 -- Loading Strategy
- Sequential and Parallel Loading
- Union Transformation
- Dynamic Lookup Cache
- Introduction to Fact Loading
- Create a Mapping

Chapter 12 -- Transformations Contd
- Create a Mapping
- Date Dimension Loading
- Lookup Transformation - Persistent Cache
- Aggregator Transformation
- Sorter Transformation
- Creating Stored Procedure

Chapter 13 -- Transformations Contd
- Normalizer Transformation
- Stored Procedure Transformation
- Active Vs Passive Transformations
- Connected Vs UnConnected Transformations

Chapter 14 -- Implementing Incremental Loading
- Create a Mapping
- Importance of Mapping Variable

Chapter 15 -- Implementing Incremental Aggregation
- Create a Mapping
- Incremental Aggregation

Chapter 16 -- Transaction and Variable Port
- Transaction Control Transformation
- Variable Ports

Chapter 17 -- Workflow Tasks
- Scheduling
- Task Link Properties
- Event Raise Task
- Event Wait Task
- Worklet

Chapter 18 -- Others
- Parameter Files
- Removing Duplicate Rows

You might also like