DATAWARE HOUSING FUNDAMENTALS

1. What is Database?

2. What is Data Warehousing?

3. Difference between OLTP Database and DWH.

4. ETL FUNDAMENTALS.

          i) Data Extraction

          ii) Data Transformation

          iii) Data Loading

5. What is ETL Client?

6. DataMart and Types of Data Marts.

7. DataWareHouse-Database Design.

         i) Star Schema.

         ii) Snow Flake Schema.

         iii) Galaxy Schema.

8. OLAP and Types of OLAPs

9. DataWareHouse Architecture.

INFORMATICA POWERCENTER 8.6.0

1. Power Center Components.

·         Power Center Clients

·         Power Center Repository.

·         Power Center Domain

·         Integration service

·         Repository Service

·         Administration Console

2. Difference between Informatica 7 and 8

3. Power Center Architecture

4. Integration Service Architecture

TRANSFORMATIONS

a). ACTIVE TRANSFORMATIONS.

Ø  Filter Transformation

Ø  Router Transformation

Ø  Aggregator Transformation

Ø  Joiner Transformation

Ø  Union Transformation

Ø  Sorter Transformation

Ø  Rank Transformation

Ø  Transaction Control Transformation

Ø  Update Strategy Transformation

Ø  Normalizer Transformation

Ø  Source Qualifier Transformation

Ø  SQL Transformation.

b). PASSIVE TRANSFORMATION

Ø  EXPRESSION TRANSFORMATION

Ø  SEQUENCE GENERATOR TRANSFORMATION

Ø  STORED PROCEDURE TRANSFORMATION

Ø  LOOKUP TRANSFORMATION

Ø  XML SOURCE Qualifier Transformation.

c). CONNECTED AND UNCONNECTED TRANSFORMATIONS.

d). FLAT FILES AND ITS TYPES.

POWER CENTER ADVANCED

1). Unconnected lookup Transformation

2). Unconnected Stored Procedure to Create and Drop Index

3). Mapplet And Types Of Mapplets

4). Defining Reusable Transformations.

5). User Defined Functions.

6). Tasks And Types Of Tasks.

7). Worklet and Types Of Worklets.

8). Scheduling Work flow

9). Constraint Based Laod Ordering.

10). Target Load Plan

11). Types Of Batch Processing

12). Link conditions

13). Mapping Parameters

14). Mapping Variables

15). Defining Session Parameters

17). Session Recovery

18). Difference Between Normal and Bulk Loading.

19). Push Down Optimization.

20). PMCMD Utility

21). PMREP Utility

22). Incremental Aggregation

23). TYPES Of LookUp Caches.

               a) Static LookUp Cache

                b) Dynamic LookUp Cache

                 c) Perisistance lookup Cache

                 d) Shared LookUp Cache

24). Sorter and Rank Cache.

25). ETL UNIT Testing (8 test Cases)

26). ETL PERFORMANCE TESTING (3 test cases)

27). ETL Performance

Optimization techniques

28). Task Implementations.

o   Session

o   Command

o   EMAIL

o   Timer

o   Event Wait

o   Event Raise

o   Decision

o   Assignment

o   Control

o   Worklet

Courses Offered in Our Training Institute:

Ø  IBM Lotus Notes Domino Server Administration

Ø  IBM Lotus Notes Development

Ø  IBM Web Sphere Application Server Administration

Ø  IBM Web Sphere Process Server Administration

Ø  IBM Web Sphere MQ Administration

Ø  Oracle Apps R12 HRMS Functional

Ø  Oracle Apps R12 SCM

Ø  Oracle Apps R12 Financial

Ø  Oracle APPS Technical

Ø  Oracle FUSION , SOA

Ø  Tibco

Ø  Tibco I Process

Ø  Webmethods

Ø  Siebel CRM, EAI

Ø  Microstrategy

Ø  JAVA, J2ee

Ø  Springs, Hibernate and Webservices

Ø  Dotnet

Ø  SharePoint

Ø  Testing TOOLs  - QTP, QC , Load Runner

Ø  SQL SERVER

Ø  OBIEE 11 g

Ø  Informatica

Ø  Android

Ø  WCF,WPF,Linq,SilverLight

Visit for the course content www.futurepointtech.com

Mail us for details   info@ futurepointtech.com