Informatica Online Training

Data Ware Housing Concepts        

·         Introduction to Data Warehousing

·         Introduction to OLTP

·          ETL and OLAP Systems

·         Dimensional Modelling

·         Types of Schema’s

·         Types of Fact and Dimension Tables

·         Why do we Need ETL tools

·         What is Informatica? 

Power Centre Components 

·         Informatica Architecture

·         Designer 

·         Repository Manager 

·         Workflow Manager 

·         Workflow Monitor 

Informatica Concepts and Overview 

·         Source Qualifier 

·         Target Designer 

·         Transformations

·         Mappings & Mapplets

·         Sessions

·         Workflows & Work lets

·         Tasks 

Sources 

·         Working with Relational Sources

·         Working with Flat Files (Direct/Indirect) 

Targets 

·         Working with Relational Targets

·         Working with Flat file Targets 

Transformations

·         Active and Passive Transformations

·         Connected and Unconnected Transformations

·         Reusable,

·         Non Reusable & Shortcuts

·         Expression

·         Source Qualifier

·         Filter

·         Joiner

·         Sorter

·         Rank

·         Router

·         Union

·         Aggregator

·         Sequence Generator

·         Lookup

·         Stored Procedure

·         Update Strategy

·         Normaliser

·         SQL Transformation

·         Transaction Control

·         Mapplet input and Output transformation

Implementation of Slowly Changing Dimensions

·         Type-1

·         Type-2

·         Type-3

Cache concepts (Lookup, Aggregator, Joiner, Sorter)

·         Tasks

·         Start

·         Session

·         Assignment

·         Event raise and Event wait

·         Email

·         Command

·         Decision

·         Timer

·         Control

Advanced features

·         Incremental Aggregation

·         Mapplet Implementation

·         Target Load Plan

·         Target update override

·         Constraint Based loading

·         Mapping Parameters & Variables

·         Session Parameters

·         Link Conditions

·         Performance Tuning 

Real Time scenarios & FAQ’s

Contact Us: +91-900-044-4287