+91-80999 02123201-710-8393

Informatica Online Training

Course Name: Informatics Online Training
Course Duration :  30 Hours

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

    • Power Center Architecture
    • Power Center 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

More about Informatica Online Training, About  Informatica Trainer, Informatica Online Training batch information:

Address

#3-5-839/6, 104, 1st Floor, LR Plaza, Beside Bharat Petrol Pump, Hyderguda,
Hyderabad - 500 029

Phone     : 040- 6464 5154
Email      : info@careeronlinetrainings.com
Website : www.careeronlinetrainings.com

Skype ID : careeronlinetrainings

Testimonials

The course content was appropriate and useful. The online trainers were competent and useful. The best thing about the course was the young learner and learning Vs acquisition section.

The thing that the course needs improvement is the format of the assignment

Keerthi
Hyderabad.

I am Mushtak Shaik from Hyderabad. The course content was appropriate and useful. The online trainers were competent and useful.

The thing that the course needs improvement is the format of the assignment


Mushtak Shaik
Hyderabad.