Data Warehousing and Informatica PowerCenter
Week1 Day 1
v Introduction & Architecture of Data warehouse
v Characteristics of Data warehouse.
v Principles of Data warehouse.
v Benefits of DWH.
v Approaches of Data warehousing.
v DWH Lifecycle
v Online Transaction Processing (OLTP)
v Online Analytical Processing (OLAP)
v Difference between OLAP & OLTP
v Data Model concept (ER & Dimensional modeling)
v Dimension table and their Types
v Fact Table & their Types
v Schemas
v Star schema
v Snowflake schema
v Starflake schema
v ODS
v Hierarchies
v Cube
v SCD Concept & Types
Week1 Day 2
Introduction to Informatica 1
v Overview of Informatica
v Informatica Products
v Informatica Architecture
v Different Components of Informatica and their uses.
1. PowerCenter Domain
2. PowerCenter Repository
3. Integration Service
4. Repository Service
5. PowerCenter Client Tools
6. PowerCenter Administration Console
Introduction to Informatica 2
v 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
v Detailed description about Power Centre Designer
Components of Designer and key roles
³ Source Analyzer
1. Import Source structure from relational tables.
2. Import Source structure from flat file.
3. Manual creation
³ Target Designer
1. Import Target structure from relational tables.
2. Import Target structure from flat file.
3. Define Tables and Create them in the Database
³ Transformation Developer
1. Create sharable, re-usable transformation.
2. How to check Dependencies
³ 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
v What is a transformation?
v Different types of transformations (Active, Passive)
v Connected and Unconnected Transformations
v List of transformations
v Basic uses of Transformations
v Working with transformations
v What is a
1. Source Qualifier Transformation.
2. Expression Transformation.
3. StoredProcedure Transformation.
v Uses of Transformations
v Working with the Transformation.
v Direct and Indirect Flat File Loading.
Week2 Day 2
v 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)
Features at “INFOERA”:
v Informatica training provided by real time work experience Trainer with 6+ Years in IT Industry.
v We help you to change your current domain to Informatica domain and Get a Dream JOB
v Informatica training with Real time case studies and live examples with Project Explanation.
v Hands on & Practical Classes after the completion of every major topic of the module by Informatica Instructor.
v Our Informatica students provided with Informatica server access throughout the course.
v At Infoera, ETL Tool Training Course is very economical and best suits the Informatica industry.
v Our trainers provide specially made Latest material for Informatica ETL training
v We Provide Informatica tests and FAQ’s from interviews point of view.
Infoera Software Training Institute
#844, 2nd Floor, 5th main, Double Road, Indiranagar 1st Stage, Bangalore-38.
Landmark : Above Ibaco Ice-cream Parlor
Direction:KFC Metro Station HDFC Bank Signal and take right Take 2nd Right which is a 5th Main.
PHONE:8150974678