India-flagINDIA : +91-8099902123   usa-flagUSA : 201-710-8393
Call Me Back

training courses

Informatica online Training

DATAWAREHOUSING CONCEPTS

INTRODUCTION TO DATAWAREHOUSING

  • Data Warehousing Concepts
  • Dataware housing (what/Why/How)
  • Data Modelling(Schemas, FACTS and DIMENSIONS)
  • Slowly Changing Dimensions
  • Metadata
PowerCenter Components and User Interface
  • PowerCenter Architecture
  • PowerCenter Client Tools
  • Lab – Using the Designer and Workflow Manager
Source Qualifier
  • Source Qualifier Transformation
  • Lab Project Overview
  • Lab A – Load Payment Staging Table
  • Source qualifier Joins
  • Lab B – Load Product Staging Table
  • Source Pipelines
  • Lab C – Load Dealership and Promotions Staging Table and Real time issues
Expression, Filter, File Lists and Workflow Scheduler
  • Expression Editor
  • Filter Transformation
  • File Lists
  • Workflow Scheduler
  • Lab – Load the Customer Staging Table and Real time issues
Joins, Features and Techniques I
  • Joiner Transformation
  • Shortcuts
  • Lab A – Load Sales Transaction Staging Table
  • Lab B – Features and Techniques I and Real time issues
Lookups and Reusable Transformations
  • Lookup Transformation
  • Reusable Transformations
  • Lab A – Load Employee Staging Table
  • Lab B – Load Date Staging Table and Real time issues
Debugger
  • Debugging Mappings
  • Lab – Using the Debugger
Sequence Generator
  • Sequence Generator Transformation
  • Lab – Load Date Dimension Table and Real time issues
Lookup Caching, More Features and Techniques
  • Lookup Caching
  • Lab A – Load Promotions Dimension Table
  • Lab B – Features and Techniques II
  • Review and more Lab Activities and Real time issues
Router, update Strategy and Overrides
  • Router Transformation
  • Update Strategy Transformation
  • Expression Default Values
  • Source Qualifier Override
  • Target Override
  • Session Task Mapping Overrides
  • Lab – Load Employee Dimension Table and Real time issues
Dynamic Lookup and Error Logging
  • Dynamic Lookup
  • Error Logging
  • Lab – Load Customer Dimension Table
Unconnected Lookup, Parameters and Variables
  • Unconnected Lookup Transformation
  • System Variables
  • Mapping Parameters and Variables
  • Lab – Load Sales Fact Table
Sorter, Aggregator and Self-Join
  • Sorter Transformation
  • Aggregator Transformation
  • Active and Passive Transformations
  • Data Concatenation
  • Self-Join
  • Lab – Reload the Employee Staging Table and Real time issues

SCD type1 – LAB

SCD type2 – LAB

SCD type3 – LAB

Mapplets
  • Mapplets
  • Lab – Load Product Daily Aggregate Table
  • Review and more Lab Activities and Real time issue
Workflow Variables and Tasks
  • Link Conditions
  • Workflow Variables
  • Assignment Task
  • Decision Task
  • Email Task
  • Lab – Load Product Weekly Aggregate Table
More Tasks and Reusability
  • Event Raise Task
  • Event Wait Task
  • Command Task
  • Reusable Tasks
  • Reusable Session Task
  • Reusable Session Configuration
Worklets and More Tasks
  • Worklets
  • Timer Task
  • Control Task
  • Lab – Load Inventory Fact Table

If you want to know more about Informatica Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com