Jump to content

Informatica Online Training


cssadhar

Recommended Posts

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...