course detail

Informatica Training

Informatica Training in Chennai

Informatica Training  In Chennai At BITA Academy– No 1 Informatica Training Institute in Chennai. Call 956600-4616 For More Details.

Informatica Course Syllabus

Data Warehouse Introduction

What is DWH?

Characteristics of Datawarehouse

Difference between OLTP and DWH

Architecture of DWH

Various BI tools

Types of DWH

Types of Dimensional Data Modeling

Surrogate key

Types of Dimension

Power Center Components

Designer

Repository Manager

Workflow Manager

Workflow Monitor

Power Center Admin Console

Informatica Concepts and Overview

Informatica Architecture

Sources

Working with relational Sources

Working with Flat Files

Targets

Working with Relational Targets

Working with Flat file Targets

Transformations – Active and Passive Transformations

Expression

Lookup –Different types of lookup Caches

Sequence Generator

Filter

Joiner

Sorter

Rank

Router

Aggregator

Source Qualifier

Update Strategy

Normalizer

Union

Stored Procedure

Slowly Changing Dimension

SCD Type1

SCD Type2 – Date, Flag, and Version

SCD Type3

Workflow Manager

Creating Reusable tasks

Workflows, Worklets & Sessions

Tasks

Session

Decision task

Control Task

Event wait task

Timer task

Monitoring workflows and debugging errors

Indirect Loading

Constraint-based load ordering

Target Load plan

Worklet, Mapplet, Reusable transformation

Migration–XML migration and Folder Copy.

Scheduling Workflow

Parameter and variables

XML Source, Target, and Transformations

Performance Tuning

Pipeline Partition

Dynamic Partition

Pushdown optimization

Free Demo Classes