datawarehouse online training institute from hyderabad india

Contact No: 091- 988 502 2027 Email: [email protected]

Data Warehouse Training Course Out line SVR Technologies

SVR Technologies

Contact: 091-9885022027

Email: [email protected]

Course Name: Data Warehousing

Trainer: Parikshit

Each Session: 1 Hour Duration: 29 sessions



Session 1

a) Introduction to Data Warehouse

b) Different steps in Data Warehouse

c) Components and models of Data Warehousing Technologies

d) Star Schema, Snow Flake Schema

e) What if Informatica, where it fits in Data Warehouse?

f) Introduction to Informatica

Session 2

a) Different Components of Informatica and their uses

b) Introduction to Power Centre Designer and key roles

c) Introduction to Power Centre Workflow Manager and key roles

d) Introduction to Power Centre Workflow Monitor and key roles

e) Introduction to Power Centre Repository Manager and key roles

Session 3

a) Detailed description about Designer

b) Components of Designer and key roles

c) Source Analyzer

d) Target Designer

e) Transformation Developer

f) Mapplets Designer

g) Mapping Designer

Session 4

a) Working with Queues and Excersises



Session 5

a) Uses of Source Qualifier

a. Overrides

b. Source Filters

c. Options.

b) User Information Details

a. Conditions

b. Scenarios

Session 6

a) Router Transformation

a. Options

b. Groups

b) Sequence Generator Transformation

Session 7

a) Expression Transformation

a. Uses

b. Different Ports (Input, Output, Variable)

b) Joiner Transformation

Session 8

a) Lookup Transformation

a. Uses

b. Implementation

c. Conditions

d. Connected, Unconnected

b) Rank Transformation



a. Uses

b. Options

Session 9

a) Sorter Transofrmation

a. Uses

b. Options (Up, Down)

b) Union Transformation

Session 10

a) Update Strategy Transformation

a. Options

b. Insert, Update, Delete, Reject

b) Transaction Control

Session 11

a) Aggregator Transformation

b) Normalizer Transformation

Session 12

a) Mapplets

b) Use of Mapplets, and how to create them

c) Use of re-usable transformations

Session 13



a) Different load types

b) Truncate and Load approach

c) Snapshot Load approach

d) Slowly Changing Dimension approach

Session 14

a) SCD -1 (Slowly Changing Dimension -1)

b) SCD -2 (Slowly Changing Dimension -2)

c) SCD -3 (Slowly Changing Dimension -3)

Session 15

a) Different options and tips in Designer

b) Revision of Power Center Designer

Session 16

a) Detailed description about Workflow Manager

b) Components of Manager and key roles

c) Task Developer

d) Worklet Designer

e) Workflow Designer

f) Different Tasks

Session 17

a) Creating a reusable session

b) Decision Task

c) Command task



d) E-mail Task

e) Event-Raise task

f) Event-Wait task

g) Timer Task

Session 18

a) Creating a workflow

b) Different options

c) Link Conditions

d) Failing Tasks

e) Using different tasks in a workflow

Session 19

a) Handling Load Strategies

b) Load modes (Bulk, Normal)

c) Owner Names

d) Overriding Table Names

e) Overriding the SQL’s

f) Handling Inserts, Updates, Deletes

Session 20

a) Different options and tips in Workflow Manager

b) Revision of Power Center Workflow Manager

Session 21

a) Power Centre Workflow Monitor



b) Power Centre repository Manager

Session 22

a) About Database

b) Knowledge required for an Informatica Developer

c) Different basic commands

Session 23

a) Next Level Commands

b) Joining different tables

c) Complex cases

d) Tips while using database

Session 24

a) Revision of all the components (Designer, Manager, Monitor)

Session 25

a) Live Scenarios and Explanation

b) Implementing Different Logics

Session 26

a) Key tips

b) Different Issues

c) Handling Issues



Session 27

a) Uses and importance of Parameters

b) Creating a Workflow level parameter script

c) Creating a Session level parameter script

Session 28

a) Informatica Interview Questions

b) Clarifying Doubts

Session 29

a) Over view of what we’ve learnt

b) Providing Informatica Material required

c) Another session on any topic of your choice (If required)

datawarehouse online training institute from hyderabad india

Education