Informatica Online Training

Retors Lernen Labs offers best Informatica Online Training in Countries like
India, USA, UK and Canda, and cities like Hyderabad, Bangalore, Delhi and
Chennai

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

If you want to know more about Informatica Online Training do not hesitate to
call +91-7032670921 or mail us on retorslernenlabs@gmail.com.

For more details, visit us at
http://www.retorslernenlabs.com/informatica-online-training/

1) Education and Training►Online Education
2) Services►Computer Services

India ► Andhra Pradesh

Informatica Online Training

seoretorslernenlabs@gmail.com

Total Flags Achieved

0 Spam 0 Not Spam 0 Don't Know

Flags