Informatica

INFORMATICA

INFORMATICA SYLLABUS

DATA WAREHOUSING INTRODUCTION

BASIC CONCEPTS

VIEWS AND DIMENSION

INFORMATICA INTRODUCTION

—————————

INTRO TO ETL

INFORMATICA INTERGRATION SERVICE ARCHITECTURE OVERVIEW

INFORMATICA CORPORATION PRODUCTS

INFORMATICA POWER CENTER CIENT

———————————

INTRO TO POWER CENTER CIENT

TYPES OF CLIENT TOOLS

i)Repository Manager

ii)Designer

iii)Workflow Manager

iv)Workflow Monitor

POWER CENTER TOOLS

———————-

INTRODUCTION TO DESIGNER

INTRODUCTION TO WORKFLOW MANAGER

WORKFLOW MONITOR

TRANSFORMATION BASIC CONCEPTS

——————————–

TRANSFORMATION OBJECTS

INFORMATICA POWER CENTER

—————————-

DATA INTEGRATION CONCEPTS :

PowerCenter Components and User Interface :

1.Source Qualifier

2.Workflow Scheduler

3. Reusable Transformations

4.Debugger

5.Detail Review of the Expression

6. Filter

7. Sorter

8.Aggregator

9. Joiner

10.Lookup

11.Update Strategy

12.Router and Sequence Generator Transformations.

13.Source and Target Overrides

14.Parameters and Variables

15.Self-Join

16.Incremental Aggregation

17.Dynamic Lookup Cache

18.Mapplets

19.Workflow Configuration and Techniques

20. Reusable Schedule for a Workflows

21 Session Configuration; Task and Worklets;

MAPPING DESIGNER

——————-

CREATE MAPPINGS

ADVANCE MAPPING TECHNIQUES

ERROR HANDLING

PERFORMANCE TUNUNIG

STORED PROCEDURES AND CUSTOM TRANSFORMATION

REPOSITORY REPORTING

PARTITIONS

WORKFLOW MANAGER

———————

CREATE WORKFLOW

ADVANCE WORKFLOW TECHNIQUES

WORKING WITH TRANSFORMATION

——————————-

.EXPRESSION TRANSFORMATION

.WORKING MAPPLETS

.LOOKUP TRANSFORMATION

CREATING CUBES AND DIMENSIONS

———————————

CREATE DIMENSION

CREATE CUBES