Informatica Online Training
Informatica Online Training
Informatica Online Training Course Content :
Informatica Power Center
- Basic Concepts of Informatica
- Overview Basic Definitions
- Informatica Products, Architecture
- Tools and their Roles
- Power Center Vs Power Mart
- Understanding Informatica Server Configuration
Informatica Designer
- Basic Concepts
- Using the Designer
- Working with Sources
- Working with Flat Files, Targets
- Mappings, Transformations, Mapplets
- Working with Debugger
- Implementing Type 1, Type2, Type 3 Mappings
- Loading the data into different fact tables
Working with Transformations
- Aggregator Transformation
- XML Transformation
- Expression, Look up Transformation
- Rank, Router, Filter, Sequence Generator
- Sorter Transformation
- Source Qualifier Transformation
- Stored Procedure Transformation
- Transaction Control Transformation
- Joiner, Union Transformation
- Java Transformation
- SQL Transformation
- XML Source Qualifier
- Update Strategy Transformation
- Mapplet Input Transformation
- Mapplet Output Transformation
- Connected Vs Unconnected Transformations
Creating Work flows
- Understanding the server Architecture
- Working with Workflows
- Working with Tasks Assignment, Command, Decision, Control, Event Raise Event Wait, Timer , Email, Session Task
- Working with Worklets
- Working with Sessions
- Understanding Commit Points
- Understanding Commit Points
- Monitoring Workflows
- Session Parameters
- Parameter files
- Using Incremental Aggregation
Data Warehousing Basic Concepts
- Data Warehouse Definition,
- Reasons for using, uses
- Characteristics of DWH
- OLTP Vs OLAP Databases
Implementation Methodology
- Kimball Methodology
- Inmon Methodology
Types of Loads
- First Time Load
- Full Load
- Incremental Load
Data Marts and Star Schema Design
- Definition of Star Schema
- Design of Dimension and Facts
- Snow Flake Star Schema
- Slowly Changing Dimensions
- Non Additive Facts
- Conformed Dimensions
Drop your query
Most Popular Courses
Achieve your career goal with industry recognised learning paths
What my Client's Say?
-
It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand
-
All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin
-
It was the best decision I had ever made in my life. Although it was expensive for me, but I don't regret even for one second. ~ Maruti Malla
-
Thank you for this great course. I learned a lot of things, I met very nice people and I am happy that I had these 6 crazy weeks with you.".~ Najmul Shar A Baig
-
Very nice and friendly tutor and staff. The course was very fruitful, particularly the input sessions during the first half of it.~ Radha Nandyala
-
It was such great experience, though it was really intensive, it was worth doing it! Cant thank enough all team effort esp Mohan! .~ Rohan Kumar
-
The course was really good because it was a practical course.~ M.Radha patel
-
I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria
