We are in process of building the inventory of good professionals in this categoryGot it!
Connect With DTech IT Education
You have reached a limit!
We only allow 20 Tutor contacts under a category. Please send us an email at firstname.lastname@example.org for contacting more Tutors.
Further Information Received
Thank you for providing more information about your requirement. You will hear back soon from the trainer
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
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.
Basic ETL Techniques
II. Informatica Powercenter 9x - Project oriented
Power Center: Terminology and Architecture
Informatica Repository Manager
Informatica Workflow manager
Informatica Workflow monitor
Expression and Filter Transformations
Joining and Merging Data
Aggregator and Sorter Transformations
Using the debugger
Updating Target Tables
Create and use reusable transformations
Mapping Design Workshop
Workflow Design Workshop
Informatica Advanced Features