Informatica

What is Informatica?

Informatica is one of the leading Data integration and Data Management companies in the world. It has customers throughout the world and its customer base includes more than 5000 companies. Some of its most popular customers are Samsung, Fannie Mae and Allianz. Its main products are Enterprise Cloud data management and Enterprise Data Integration (PowerCenter). Its products are primarily used for establishing and maintaining Data warehouses. It also has products for cloud computing integration, data masking, data virtualization etc. It also provides Data as a Service (DaaS) which helps companies to enrich and verify their data to engage with customers. Informatica’s PowerCentre, an ETL (Extraction, Transformation, and Loading) tool for data warehouses is one of the most widely used tools in data management and business intelligence gathering.

Why to enrol in Informatica Training at Trishana Technologies, Bangalore?

Because only Trishana Technologies, offer the best-in-class Informatica training which encompasses the basics of Data warehousing, a long list of products and services offered by Informatica and XML for further career growth. Our visionary experts carefully designed the syllabus of our Informatica course to satisfy the present-day expectations of the industry and to fill our students with creative and innovative knowledge which will be expected from them in future. Our training materials are the most accurate and simple to benefit all the students coming from non-English background. We will provide unlimited hours for practicing at our lab since Informatica’s products are not affordable to all of our students. We will also provide real-time projects to practice and encourage our students to solve real life issues in data management and integration. We have the best placement record among all the training institutes teaching Informatica.

Informatica Training Syllabus:

Data Warehouse Introduction

SECTION 1
Power Center Components

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

SECTION 2
Informatica Concepts and Overview

  • Informatica Architecture.

SECTION 3
Sources

  • Working with relational Sources
  • Working with Flat Files

SECTION 4
Targets

  • Working with Relational Targets
  • Working with Flat file Targets

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

SECTION 6
Workflow Manger

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

SECTION 7

  • Indirect Loading
  • Constraint based load ordering
  • Target Load plan
  • Worklet, Mapplet
  • Migration –XML migration and Folder Copy
  • Scheduling Workflow
  • Parameter and variables
  • XML Source, Target and Transformations

SECTION 8
Performance Tuning

  • Pipeline Partition
  • Pipeline Partition
  • Pushdown optimization

Career opportunities in Informatica:

  • Informatica Developer
  • Informatica Administrator
  • ETL Testing with Informatica
  • Informatica MDM Test Engineer
  • Informatica Architect