INFORMATICA POWERCENTER TRAINING
KITS Online Training Institute provides best Informatica PowerCenter training by our highly professional certified trainers. Informatica is a service oriented architecture and also has the capability to share service and resource across several machines. Informatica delivers enterprise data integration and management software powering analytics for big data and cloud. Dataware housing concepts will be taught prior to Informatica. Informatica PowerCenter is a widely used extraction, transformation and loading (ETL) tool used in building enterprise data warehouses. The components within Informatica PowerCenter aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse.We have been offering courses to consultants, companies so that they can meet all the challenges in their respective technologies.
NOTE:-
We are also providing similar courses like Cognos Online Training etc….
Informatica PowerCenter Training Course Content
Unit 1: Informatica Introduction
- Overview
- Basic Definitions
- Informatica products
- Informatica Architecture
- Folders-Sub folders
- ETL Tools and their roles
- ETL information power center / Power mart
Unit 2: Introduction To Data Warehousing
- Data warehousing (what is Data warehousing /Why Data warehousing/How Data warehousing)
- Slowly Changing Dimensions (SCD1, SCD2, SCD3)
- Metadata
- Dimensional Table
- Types Of Dim Tables
- Fact Table
- Types of Fact Tables
- OLTP (Online Transaction Processing)
- OLAP (Online Analysis And Processing)
- OLTP Vs OLAP
- Advantages of OLAP
- Different Methodologies of DWH
Unit 3: Configuration
- Informatica configuration
- Instigation Services
- ETL Folder
- ETL Job Filz
Unit 4: Introduction to Informatica Designer
- Introduction to Designer
- Logon to Designer
- Designer interfaces
- Designer Tools
- Defining Sources
- Database as a source
- Flat File sources
- Defining Targets
- Importing from database
- Creating a new target
- Creating target database objects
Unit 5: Transformation
- Aggregate Transformation
- Shorter Transformation
- Active and Passive Transformations
- How Sequencer work and Uses of Sequencer Transformation
- Filter Transformation
- Lookup transformation
- Connected lookup
- Unconnected lookup
- Joiner Transformation
- Filter Transformation
- Ranking Transformation
- Router Transformation
- Expression Transformation
- Sequence Generator Transformation
- Rank Transformation
- Stored Procedure Transformation(Connected and Unconnected)
- Union Transformation
- XML Transformation
Unit 6: Mapping
- Mapping Introduction
- Ports
- Mapping – Table to Table
- Mapping Flat File to Table
- Mapping Wizards
- Implementing Type-I, Type-II, Type-III Mappings
Unit 7: Qualifier
- Source Qualifier Transformation
- SQL override in source qualifier transformation
- Source qualifier transformation joins concept
- Source qualifier transformation on Relational Databases
- Source qualifier transformation on File systems
- Source qualifier transformation filter concepts
- Difference Between SQL Override, Other Options
- Source Qualifier to join Data
- Source Qualifier Transformation Performance Tunning
- Pre SQL and Post in Source Qualifier Transformation
Unit 8: Workflow Manager
- Workflow Introduction
- Tasks
- Workflow tools
- Connections
- Defining tasks
- Command Tasks
- Email Task
- Session Task
- Link Conditions
- Event Wait & Event Raise
- Setting Properties of Session Task
- Creating Workflow
- Starting Workflow
Unit 9: Informatica Advanced Features
- Incremental Aggregation
- Mapplet Implementation
- Target Load Plan
- Constraint Based Loading
- Mapping Variable
- Session Parameters
- Link Conditions
- Reusable Transformation
- Task and Types of Tasks
- Work let and Types of work lets
- Scheduling Workflow
- Control flow using Command task and event wait task
- Incremental Loading
Highlights of Informatica PowerCenter Training:-
* Very in depth course material with Real Time Scenarios for each topic with its Solutions for Informatica PowerCenter Trainings.
* We Also provide Case studies for Informatica PowerCenter Training.
* We do Schedule the sessions based upon your comfort by our Highly Qualified Trainers and Real time Experts.
* We provide you with your recorded session for further Reference.
* We also provide Normal Track, Fast Track and Weekend Batches also for Informatica PowerCenter Training.
* We also provide Cost Effective and Flexible Payment Schemes.