Informatica Online Training

[cssadhar]

·          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:309-200-3848