Informatica Certified Consultant Training

Informatica is used for data integration products. It offers the capability to connect & fetch data from different heterogeneous source and processing of data. Informatica Powercenter ETL is the most widely used tool and in the common term when we say Informatica, it refers to the Informatica PowerCenter tool for ETL.

This training will help you to master in various aspects of the ETL and data-ware house techniques. Informatica products are used for ETL, data masking, data quality, data replica, data virtualization, master data management, etc.

Requirement:

  • Basic knowledge of ETL concepts
  • Cloud Computing knowledge not needed.
Card image cap

Informatica Training

INR 15000/-

Trainer Profile

  • 3+ Years of teachingĀ  experience.
  • Highly qualified in the field of IT
  • Certified Professional

Inquiry

(+91) - 7248 95 3390

contactus@dsinfo.in

contactdsinfosolution@gmail.com

What you will learn

  • Data Warehousing Concepts
    • Data Warehouse
    • Data Mart
    • OLAP VS OLTP
    • Data Warehouse Architecture (Basic)
    • Data Warehouse Architecture (with a Staging Area)
    • Dimensional Modelling
    • Star Schema
    • Snowflake Schema
    • Dimension
    • Fact
    • Slowly Changing Dimension (Type 1,2 and3)
    • Hierarchy
    • Confirmed Dimension
    • Fact less Fact Table.
    • Summary / Aggregations table
    • Change Data capture
  • Power Center Components
    • Designer
    • Repository Manager
    • Workflow Manager
    • Workflow Monitor
  • Sources
    • Working with relational Sources
    • Working with Flat Files
  • Targets
    • Working with Relational Targets
    • Working with Flat file Targets
  • Informatica Concepts and Overview
    • Informatica Architecture.
    • Source Qualifier
    • Target Designer
    • Transformations
    • Mappings
    • Mapplets
    • Sessions
    • Tasks
  • Transformations
    • Expression Transformation
    • Lookup Transformation
    • Sequence Generator Transformation
    • Filter Transformation
    • Joiner Transformation
    • Sorter Transformation
    • Procedural Transformation
    • Router Transformation
    • Aggregator Transformation
    • Update Strategy Transformation
    • Union Transformation
    • Rank Transformation
    • Transaction Control Transformation
    • Normalizer Transformation
    • Source Qualifier Transformation
    • Stored Procedure Transformation
    • XML Source Qualifier Transformation
    • Debugging Mappings
  • Power Centre Transformation Language
    • Numeric functions
    • String Functions
    • Date Functions
    • Conversion Functions
    • Cleansing Functions
    • Aggregate Functions
    • User Defined Functions
  • Types of Lookup Caches
    • Static LookUp Cache
    • Dynamic LookUp Cache
    • Persistence lookup Cache
    • Shared LookUp Cache
    • Sorter and Rank Cache
  • Task Types
    • Session
    • Command
    • EMAIL
    • Timer
    • Event Wait
    • Event Raise
    • Decision
    • Assignment
    • Control
    • Worklet
  • ETL Testing
    • UNIT Testing
    • System Integration testing
    • PERFORMANCE TESTING
    • ETL Performance Optimization techniques