• 044 - 4213 3878
  • 95510 88722
  • 95510 99744
  • info@katalystglobal.com

Learn - Informatica

Informatica

Informatica® is one of the leading data integration software available in the IT market today.

Each passing day, more and more companies are joining the Informatica band wagon for achieving Data Warehousing through ETL.

Informatica is one of the most widely used ETL tools for data warehousing and business intelligence. This is the tool that provides DW solution to more than 70% of all DWBI projects today. Informatica is emerging in the market and overcoming all challenges of DWBI compared to any of its competitors.

If you are looking forward to a promising career in DWBI look no further this is your tool and we are your destination.

Informatica® is one of the fastest growing ETL tools and is way ahead in terms of market and business than any other ETL tool today.

Here at Katalyst Global Solution we will help you master this tool with interactive sessions. The advantage of mastering Informatica® here is that, the sessions will be covered by faculty working in live ETL projects thus giving you an insight into how this ETL tool used in today’s business.

So if you are looking for a promising IT career for a long time, then look no further, ETL is your answer and Katalyst Global Solution is your solution.

Please feel free to contact us for any further queries and we will connect you with our faculty.

Informatica Training Syllabus

Data Warehouse Introduction

Power Center Components

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Power Center Admin Console

Informatica Concepts and Overview

  • Informatica Architecture.

Sources

  • Working with relational Sources
  • Working with Flat Files

Targets

  • Working with Relational Targets
  • Working with Flat file Targets

Transformations – Active and Passive Transformations

  • Expression
  • Lookup –Different types of lookup Caches
  • Sequence Generator
  • Filter
  • Joiner
  • Sorter
  • Rank
  • Router
  • Aggregator
  • Source Qualifer
  • Update Strategy
  • Normalizer
  • Union
  • Stored Procedure
  • Slowly Changing Dimension
    • SCD Type1
    • SCD Type2 — Date, Flag and Version
    • SCD Type3

Workflow Manger

  • Creating Reusable tasks
  • Workflows, Worklets & Sessions
  • Tasks
    • Session
    • Decision task
    • Control Task
    • Event wait task
    • Timer task
  • Monitoring workflows and debugging errors

Indirect Loading

Constraint based load ordering

Target Load plan

Worklet ,Mapplet ,Resuable transformation

Migration –XML migration and Folder Copy.

Scheduling Workflow

Parameter and variables

XML Source, Target and Transformations

Performance Tuning

  • Pipeline Partition
  • Dynamic Partition
  • Pushdown optimization
Katalyst Training

Katalyst Global Solutions, We act as a catalyst in igniting your mind through knowledge and hense we spell it with a 'K'. We are a team of people having experience in various fields of Information Technology,we have a common goal in establishing our organisation as the final destination for people who wish to enhance their career through IT

Contact Us
Send Your Queries