reply

Posted

print

favorite this post 8/1-8/14: Informatica Developer Online Training Program hide this posting unhide

Informatica Online Training with placement assistance
Contract
Day 1:

Module 1: Data warehouse Concepts

• Business Intelligence

• Data Warehousing Concepts (What/Why/How)

• Data Modeling (Schemas, FACTS and DIMENSIONS)

• Data Mart

• Metadata

• OLAP VS OLTP

• Dimension

• Fact

• Types of Dimension tables

• Types of Fact tables

• Star Schema

• Snowflake Schema

• Slowly Changing Dimensions

• Top down and Bottom up approach

Day 2:

Module 2: SQL Concepts
• Conceptual Explanation on SQL: DDL, DML, DRL, TCL, DCL
• Constraints, Joins, sub queries, Analytical functions

• 200 exercises for self study & Practice

Day 3:

Module 3: E T L Informatica Power Center 9.X.X

• Why do we need ETL tool and Why Informatica?

Introduction to Informatica

• Introduction
• Getting started

• Informatica Suite Components
• Informatica Architecture

• Informatica Server

Day 4:

Module 4: Informatica Power Center Client Components
• Repository Manager

• Designer
• Workflow Manager

• Workflow Monitor


Module 5: Informatica Building Blocks

• Source & Targets
• Transformations

• Mappings

• Mapplets
• Sessions

• Workflows

Day 5:

Sources

• Working with Relational Source

• Working with Flat file Source
• Working with heterogeneous sources

Targets

• Working with Relational Targets
• Working with Flat file Targets

• Direct and Indirect file loading

Day 6:

Module 6: Different Transformations

• Active and Passive Transformations

• Connected and un-connected transformations

1. Source Qualifier Transformation

2. Filter Transformation

Lab & Self study exercises:

Day 7:

3. Expression Transformation Lab & Self study exercises:

Day 8:

4. Sorter Transformation

5. Aggregator Transformation Lab & Self study exercises:

Day 9:

6. Router Transformation

7. Rank Transformation

Lab & Self study exercises:

Day 10:

8. Sequence Generator Transformation

9. Joiner Transformation

Lab & Self study exercises:

Day 11:

10. Lookup Transformation - Connected Lookup

- Un Connected Lookup

Lab & Self study exercises:

Day 12:

11. Update Strategy Transformation

12. Union Transformation

Lab & Self study exercises:

Day 13:

13. Normalizer Transformation Lab & Self study exercises:

Day 14:

14. Transaction Control Transformation

15. Stored Procedure Transformation

Lab & Self study exercises:

Day 15:

• Mapping Parameter & Variable

• Mapplet

• Target Load Plan

• Debugger

Lab & Self study exercises:

Day 16:

Module 7: Informatica Advanced Concepts

Slowly Changing Dimension (SCD) Types

• SCD type1 - LAB

• SCD type2 - LAB

• SCD type3 - LAB

Day 17:

Module 8: Workflow task

• Decision Task

• Email Task

• Command task

• Control task

• Event wait

• Event raise

• Timer

• Lab exercise:

• Self exercise

Day 18:

Module 9: Session level Properties
• Pre and Post SQL

• Static and dynamic cache

• Persistent cache

• Parameter variable and file

Lab exercise:

Self exercise:

Day 19:

Module 10: Performance Tuning
Informatica Tuning (Source, target, mapping & Session)

• Push down optimization
• Partitioning Types

Day 20:

• Migration concepts

• Real time project explanation

• Resume Preparation

Module 11: Case studies
Case A, Case B, Case C - 15 Exercises

Contact : show contact info / show contact info
  • do NOT contact me with unsolicited services or offers

post id: 6644689210

posted:

best of [?]