Informatica Online Training
USA : +1 732 325 1626
IND : +91 888 602 3333
E-mail : onlinetrainershub.com@gmail.com
  • Our Services

    Fully designed Course training material Real time project support Assistance after completing the course

  • Why INFORMATICA

    Informatica secures you for delivering a trusted data in your production system updates. It takes 50% to 90% less time and resources required to complete ETL testing Comprehensive ETL testing coverage ensures lower business risk and greater confidence in the data.

  • About INFORMATICA

    Informatica is a powerful ETL tool used Extraction, Transformation and Loading. Extraction involve in understanding, analyzing and cleaning of source data. Transformation involves in cleaning and modifying the data according to the business requirements. Loading involves assigning dimensional keys and loading into the warehouse.

Courses Content

INFORMATICA               Course Duration  :  30 Hours

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

More about Informatica Online Training :

About  Informatica Trainer :

Informatica Online Training batch information:

Informatica is a company that offers the following tools

  • Informatica Power Centre
  • Informatica Power Exchange
  • Informatica Reporting Services

Informatica Power Centre:

Informatica Power Centre is an ETL tool which is responsible to convert source ER modeling data into dimensional modeling data. Informatica has complete End to End solutions in ETL side which satisfies all business needs in less cost.

Informatica Power Exchange:

Informatica Power Exchange is another tool from Informatica company to migrate the data from source database to Target database. Informatica Power Exchange is used for data migrations.

Informatica Reporting Services:

Informatica Reporting Services is a Reporting tool from Informatica company. Informatica Reporting Services is used for generating business reports from various databases.

In Informatica power centre We have Server software and client software. Server software is responsible for execution. Informatica power centre client software has the following components

Informatica Designer

Informatica Workflow Manager

Informatica Workflow Monitor

Informatica Repository Manager