INFORMATICA (Duration: 30 Hrs)

DATAWAREHOUSING CONCEPTS:

INTRODUCTION TO DATAWAREHOUSING

dwh

  • 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 issues

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