Palium Skills - Professional Training Institute in Kolkata | Oracle | PMP Certification| ITIL Certification | Java J2EE | Web Designing | Android | iOS | Final Yr Projects | Big Data | Staad pro  | Primavera | GD PI

header photo
Rahul Chatterjee cleared his PMP Certification in his first attempt! Sumana Halder cleared her ITIL V3 Foundation exam with high marks! Monojit offered a job by Hindalco after completing his Oracle course! Subhamay placed with HP as an Oracle DBA

Informatica ETL Course Training

A proud participant of our course receiving the Certificate
Informatica® is one of the leading data integration software available in the IT market today.

Why study Informatica?
  • 71% enterprises to adopt hybrid or cloud-only analytics by 2018 – IDG Research Report
  • Cloud-based BI is fastest growing BI segment; to reach $2.94 billion by 2018 – Redwood Capital Report
  • Informatica Powercenter is the most widely adopted ETL Technology – Forrester Research
Informatica is the market leader in the ETL segment. It can work on a wide variety of data sets, varying standards and multiple applications and systems. Thus it is rapidly being adopted by organizations around the world providing huge job opportunities for professionals with the right skills. These Informatica classes will prepare you for passing Informatica certification.

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.

At Palium Skills we will help you master this tool with interactive sessions and hands-on practice. 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 Palium Skills is your solution.

This training course lets learners grasp advanced skills like Informatica Installation, Configuration and Administration using PowerCenter. You will be able to test and monitor critical data processing using automated, scalable and auditable approach. Get trained in Workflow Informatica, Repository Management and other processes.

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

Details of Informatica Course

Mode: Classroom

Duration: 40  hours                                                                                                                  

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
 


Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save