INFORMATICA Online Training
Informatica Training in India, USA, UK, Saudi and Singapore.
Course : Informatica Online Training
Duration : 30 hours
Faculty : Realtime experience
ActivMaxis: is Informatica Online Training Provider in world wide. We are providing Best Informatica Training in INDIA, USA, UK, SINGAPORE, SAUDI.
Highlights in our Informatica Training :
- Technical Support
Interview Questions
Sample Resumes - Excellent Informatica Training Material with real time scenarios given by our experienced Trainer.
We are providing Informatica Training by highly qualified trainer.
We will provide Regular session’s at student flexible timings.
We will cover each topic with real time solutions.
We are providing regular sessions and weekend sessions.
Informatica Online Training Content:-
INTRODUCTION TO DATAWAREHOUSING
- Data Warehousing Concepts
- Dataware housing (what/Why/How)
- Data Modelling(Schemas, FACTS and DIMENSIONS)
- Slowly Changing Dimensions
- Metadata
Power Center Components and User Interface
- PowerCenter Architecture
- PowerCenter Client Tools
- Lab – Using the Designer and Workflow Manager
Introduction to Informatica Power Center Designer
- Source Analyzer
- Target Designer
- Mapping Designer
Informatica Power Center Workflow Designer
- Workflow Designer
- Task developer
- Worklet Designer
Informatica Powercenter Workflow Monitor
- Job status
- Job session logs
Loading Strategy
- Flat file to flat file load
- Flat file to database load
- Database to database load
- Database to flat file load
- Xml file to database load
- Xml file to flat file load
Different Transformations
- Source Qualifier
- Source Qualifier Join
- Source Qualifier Filter
- Expression
- Connected Stored Procedure
- Unconnected Stored Procedure
- Sequence Generator
- Aggregator
- Filter
- Lookup
- Joiner
- Router
- Rank
- Sorter
- Union Transformation
- Xml Source Qualifier
- Using Flat Files as Sources
- Using Flat Files as Source and Target
- Using XML Files as Source
- Reading Data From Multiple Databases
- Target Load Plan
Informatica Administration
- Installation of Informatica
- Installation of Oracle Database
- Installation of SQL Server
- Creation Repository
- Creation of Users
- Assigning Privileges to users
- Creation of Groups
- Adding the Repository to Informatica Repository Manager
- Creating Data source Connections
- Configuration of Sql server and Oracle Database with Informatica
- Scheduling the Workflow
Source Qualifier
- Source Qualifier Transformation
- Source Pipelines
- Source Qualifier Filter and Real time issues
- Source Qualifier SQL over query
Expression, Filter, File Lists and Workflow Scheduler
- Expression Editor
- Filter Transformation
- File Lists
- Workflow Scheduler
- Lab – Load the Customer Staging Table and Real time issues
Joins, Features and Techniques
- Joiner Transformation
- Shortcuts
- Lab – Features and Techniques I and Real time issues
Lookups and Reusable Transformations
- Lookup Transformation
- Reusable Transformations
- Lab A – Load Employee Staging Table
- Lab B – Load Date Staging Table and Real time issues
Debugger
- Debugging Mappings
- Lab – Using the Debugger
Sequence Generator
- Sequence Generator Transformation
- Lab – Load Date Dimension Table and Real time issues
Router, update Strategy and Overrides
- Router Transformation
- Update Strategy Transformation
- Expression Def ault Values
- Source Qualifier Override
- Target Override
- Session Task Mapping Overrides
- Lab – Load Employee Dimension Table and Real time issues
Dynamic Lookup and Error Logging
- Dynamic Lookup
- Error Logging
- Lab – Load Customer Dimension Table
Unconnected Lookup, Parameters and Variables
- Unconnected Lookup Transformation
- System Variables
- Mapping Parameters and Variables
- Lab – Load Sales Fact Table
Sorter, Aggregator and Self-Join
- Sorter Transformation
- Aggregator Transformation
- Active and Passive Transformations
- Data Concatenation
- Self -Join
- Lab – Reload the Employee Staging Table and Real time issues
SCD type1
SCD type2
SCD type3
Mapplets
- Mapplets
- Review and more Activities and Real time issues
Workflow Variables and Tasks
- Link Conditions
- Workflow Variables
- Assignment Task
- Decision Task
- Email Task
More Tasks and Reusability
- Event Raise Task
- Event Wait Task
- Command Task
- Reusable Tasks
- Reusable Session Task
- Reusable Session Configuration
Worklets and More Tasks
- Worklets
- Timer Task
- Control Task
- Lab – Load Inventory Fact Table
For more details about Informatica Training fill the training enquiry form we will get you soon with full details.