Informatica Online Course Content Details

In our informatica online training course we will cover all the core topics, our trainer are well experienced in teaching more than 5+ years, we can provide you job oriented training, with our e-learning you can enhance in your skills within a short span of time. we also provide you basic understanding of data warehousing concepts to understand the well. we will provide both online class room training and offline class room training. we will provide you record sessions, our course duration :30 hours

DATA WAREHOUSING CONCEPTS:

INTRODUCTION TO DATAWAREHOUSING

  • Data Warehousing Concepts
  • Dataware housing (what/Why/How)
  • Data Modelling(Schemas, FACTS and DIMENSIONS)
  • Slowly Changing Dimensions
  • Metadata

Informatica PowerCenter Components and User Interface

  • PowerCenter Architecture
  • PowerCenter Client Tools
  • Laboratory – 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
  • Laboratory – 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
  • Laboratory – 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

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

Laboratory  – Load Product Daily Aggregate Table

Workflow Variables and Tasks

  • Link Conditions
  • Workflow Variables
  • Assignment Task
  • Decision Task
  • Email Task
  • workshop – 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 :

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

Designer

Workflow Manager

Workflow Monito

Repository Manager