Informatica Training

 

Go Training’s offers the best Informatica Online Training Course is designed by IT Professionals with the IT Industry Specialists as our trainers are experienced and certified trainers. They share their experience, tips and tricks in the Informatica Online Training course. We are also delighted to be one of the best leading IT online training with best experienced IT professionals and skilled resources. We have been offering courses to consultants, companies so that they can meet all the challenges in their respective technologies.

 

Informatica PowerCenter is an enterprise data integration platform working as a unit. With its high availability as well as being fully scalable and high-performing, PowerCenter provides the foundation for all major data integration projects and initiatives throughout the enterprise.

 

Informatica Training Course Content

 

Data warehousing Concepts

Introduction To Data warehousing

 

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

 

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

 

  • Joiner Transformation
  • Shortcuts
  • Lab A – Load Sales Transaction Staging Table
  • Lab B – Features and Techniques I and Real time issues

 

Look ups 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 – LABMapplets

 

  • 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

 

Contact for more details on informatica Training  +91 9063320459   informatica Online Training

 

 

Hyderabad|Pune|Mumbai|Bangalore|Kolkata|Chennai|Delhi|Noida|Gurgon|Bhuvaneswar|Pune|Cochin

 

US|UK|Canada|Malaysia|Australia|New Zealand|Germany|France|Dubai|Russia|Austria|Switzerland

 

Key words:

 

informatica training online, online informatica training india,informatica training institutes in ameerpet hyderabad,online informatica training hyderabad, informatica training online usa , informatica online training from india , informatica online training , best informatica training institute in hyderabad.