Course Name      :  Informatica online training

Course Duration :  30 Hours

INFORMATICA

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