100% job oriented training by 10+ years experienced trainer. This hands on Informatica training training provides the required skills and practical knowledge required for developers to implement data integration projects & data migration projects by learning the core features of PowerCenter. Why DTecH? * Oracle Partner & Pearson Vue Test Center * 100% Satisfaction Guaranteed * Trained more than 2000 students on Oracle & DW/BI in past 4 years. * Conducted more than 60,000 hours of trainings in past 4 years. * More than 80 Senior consultant trainers worked with us in 4 years.

Topics Covered

Duration: 10-12 days/ 3 hours per day

Availability: Batches available for Weekend & Online trainings

Project: Project included along with the course

Infrastructure: High End Servers & Setups available for Lab practice

Trainer Profile: 10+ Experienced real time Professional working with leading MNC

Pre-requisite/s: Working knowledge of SQL

Topics Covered:

I. Data Warehousing Concepts
What is and OLTP?
What is Data Warehouse?
OLTP Vs Data Warehouse?
Why do you need Data Warehouse?
How do you build Data Warehouse?
Data Warehousing Technology
Definitions and descriptions
Data Warehouse Architecture
Introduction to BI tools
Introduction to ETL tools
Data Warehouse – Infrastructure
Top Down Vs Bottom Up Approach
Data Warehouse Vs Data Marts
Standalone Data Marts
Enterprise Data Warehouse
Operational Data Store (ODS)
OLAP, ROLAP, MOLAP, HOLAP
Star Schema Vs Snow Flake Schema
Facts & Dimensions
Type 1, Type 2 and Type 3
Slowly Changing Dimension updates
Surrogate key Concept.
Data Staging
Basic ETL Techniques

II. Informatica Powercenter 9x - Project oriented
Power Center: Terminology and Architecture
Informatica Repository Manager
Informatica Designer
Informatica Workflow manager
Informatica Workflow monitor
Mapping Fundamentals
Workflow Fundamentals
Expression and Filter Transformations
Joining and Merging Data
Lookup Transformation
Aggregator and Sorter Transformations
Using the debugger
Updating Target Tables
Mapping Techniques
Create and use reusable transformations
Mapplets
Controlling Workflows
Mapping Design Workshop
Workflow Design Workshop
Informatica Advanced Features

Who should attend

Any BE/MCA graduate who wish to work in Data Warehousing -ETL Any working professional who wish to switch their career to Informatica

Pre-requisites

Stong knowledge of SQL

What you need to bring

Notebook and pen""

Key Takeaways

Learn how to use Informatica PC with atmost easiness by working around with its excellent Graphical interface. Also learn to crunch huge volumes of data using its complex architecture and innovative performance.