Informatica course for advanced learners by Info Era

Data Warehousing and Informatica PowerCenter
Week1 Day 1
Introduction & Architecture of Data warehouse
Characteristics of Data warehouse.
Principles of Data warehouse.
Benefits of DWH.
Approaches of Data warehousing.
DWH Lifecycle
Online Transaction Processing (OLTP)
Online Analytical Processing (OLAP)
Difference between OLAP & OLTP
Data Model concept (ER & Dimensional modeling)
Dimension table and their Types
Fact Table & their Types
Schemas
Star schema
Snowflake schema
Starflake schema
ODS
Hierarchies
Cube
SCD Concept & Types
Week1 Day 2
Introduction to Informatica 1
Overview of Informatica
Introduction to Informatica 2
PowerCenter Client Tools
1. Power Centre Designer and key roles
2. Power Centre Workflow Manager and key roles
3. Power Centre Workflow Monitor and key roles
4. Power Centre Repository Manager and key roles

Detailed description about Power Centre Designer
Mapplets Designer
1. Create Mapplet.
2. How to use in Mappings
Mapping Designer
1. How to create a mapping
2. Create a copy of existing mapping.
3. Validating a Mapping
Week2 Day1
What is a transformation?
Different types of transformations (Active, Passive)
Connected and Unconnected Transformations
List of transformations
Basic uses of Transformations
Working with transformations

What is a
1. Source Qualifier Transformation.
2. Expression Transformation.
3. StoredProcedure Transformation.
Uses of Transformations
Working with the Transformation.
Direct and Indirect Flat File Loading.

Week2 Day 2
What is a
4. Filter Transformation.
5. Router Transformation.
6. Rank Transformation
7. Update Strategy Transformation.
Uses of Transformations
Working with the Transformation.

Week3 Day 1
What is a
8. Lookup Transformation.
9. Sorter Transformation.
10. Union Transformation
11. Aggregator Transformation.
Uses of Transformations
Working with the Transformation.
Week3 Day 2
What is a
12. Sequence Generator Transformation.
13. Joiner Transformation.
14. Normalizer Transformation
15. Transaction Control Transformation.
Uses of Transformations
Working with the Transformation.
Week4 Day 1
What is a Mapplet?
How to create and where to use Mapplet.
Use of reusable Transformation.
What is a
16. Input Transformation.
17. Output Transformation.
18. SQL Transformation
19. Java Transformation.
Uses of Transformations
Working with the Transformation.
Week4 Day 2
Concept of Full Load and Incremental Load
Slowly Changing Dimension approach
SCD -1 (Slowly Changing Dimension -1) mapping implementation.
SCD -2 (Slowly Changing Dimension -2) mapping implementation.
SCD -3 (Slowly Changing Dimension -3) mapping implementation.

Week5 Day 1

What is Target Load Plan and its use?
Mapping Parameters
Mapping Variables

Week5 Day 2
Components in Power Centre Workflow Manager
Creation of Connection in Workflow Manager
Type of Task
1. Session
2. Decision
3. Command
4. E-mail
5. Event-Raise
6. Event-Wait
7. Timer
Creation of Workflow
How to design a workflow to run tasks sequentially or concurrently.
What is a Worklet and its use in the workflows.
Week6 Day 1
Working with Power Centre Workflow Monitor
Working with Power Centre Repository Manager
Scenario Based mapping development 1
Week6 Day 2
Use of Parameter files and its benefits.
How to debug the mapping using the Debugger.
Scenario Based mapping development 2

Free Courses with Informatica at INFOERA
Basics of UNIX (which is required for informatica operations in real time)
Basics of SQL (Mandatory and prerequisite for Informatica)