Informatica PowerCenter Certification Training
Informatica power centre is widely used extraction, transformation and loading tool implemented in developing enterprise data warehouses. PowerCenter provides a solid infrastructure to develop applications on a reusable and flexible platform, meanwhile implanting resiliency, recovery, and failover capabilities. During the training phase, trainees will learn few key skills in Informatica Powercentre like creating transformations, mappings, reusable objects, sessions and workflows to retrieve, alter and load data. Attain expert level knowledge in topics like FTL, Troubleshooting, and Debugger usage tools.
Key features
Master the admin console
Comprehend the Designer screen & repository manager screen
Master various transformations concepts
Implement SCD1, SCD2, and SCD3 mappings
IBM, TCS, Capgemini, Fujitsu, Infosys, Wipro, cognizant, L&T, Accenture hires Informatica Powercenter Developer
Drop us a Query !!!
Table of Content
Gain comprehensive PowerCenter skills for the development of data management projects working with PowerCenter Designer, Workflow Manager, and Workflow Monitor tools. This two class track with certification also provides advanced skills in transformations and transaction controls, as well as, performance tuning and troubleshooting for an optimized PowerCenter environment. Get Details on Classes, Fees, classroom or Online Training, Placement and Coaching in Mumbai, Thane, Navi Mumbai and India.
Data Warehousing
- History, Advantages, Usage etc
- Theoretical & Technical Architecture
- Functions of DWH
- Data Marts
- Data Mart concept
- Top Down Approach
- Bottom up Approach
Data Modeling
- Data Modeling Concepts.
- Dimension modeling & OLTP system.
- Dimension & Fact
- Schema generation
- Star & Snow Flake Schema
- SCD concepts (Slowly changing dimension)
- Type-1 SCD
- Type-2 SCD
- Type-3 SCD
Advanced Concepts
- Loading text file in indirect method
- Working with Mapplet
- Working with Worklet
- Workflow Scheduling
- Batch Processing
- Session Parameter
- Mapping Debugger
- Target Load Plan
- SCD Type 1 & Type 2 implementation
Informatica
- Data Acquisition
- Data Extraction
- Data Transformation
- Data Loading
- ETL Development Life Cycle
- Informatica Architecture
- Informatica Power center components & User Interface
- Different types of Sources & Targets
- Working with Database, Flat file.
- Basic Simple Pass mapping
- Use of Transformations:
- Source Qualifier T/R
- Sorter T/R
- Filter T/R
- Router T/R
- Rank T/R
- Expression T/R
- Sequence Generator T/R
- Aggregator T/R
- Union T/R
- Joiner T/R
- Lookup T/R
- Update Strategy T/R
- Normalizer T/R (Advanced concept)
- Different Types of Tasks
- Mapping Parameter & Mapping Variables