Course Content

Course Name      :  Informatica Online Training

Course Duration  :  30 Hours

Informatica Data Warehousing Concepts

Introduction to Data Warehousing

• 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, Aggregate and Self-Join

• Sorter Transformation
• Aggregation 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 Re usability

• 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