Informatica

Reading Time: 2 minutes

Informatica

    Module 1: Data Warehousing Concepts

    • Data Warehouse
    • Data Mart
    • OLAP VS OLTP
    • Data Warehouse Architecture (Basic)
    • Data Warehouse Architecture (with a Staging Area)
    • Dimensional Modeling
    • 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

    Module 2: Power Center Components

    • Designer
    • Repository Manager
    • Workflow Manager
    • Workflow Monitor

    Module 3: Informatica Concepts and Overview

    • Informatica Architecture.
    • Source Qualifier
    • Target Designer
    • Transformations
    • Mappings
    • Mapplets
    • Sessions
    • Tasks

    Module 4: Sources

    • Working with relational Sources
    • Working with Flat Files

    Module 5: Targets

    • Working with Relational Targets
    • Working with Flat file Targets

    Module 6: 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

    Module 7: Power Center Transformation Language

    • Numeric functions
    • String Functions
    • Date Functions
    • Conversion Functions
    • Cleansing Functions
    • Aggregate Functions
    • User Defined Functions

    Module 8: ADVANCED INFORMATICA CONCEPTS

    • Unconnected lookup Transformation
    • Unconnected Stored Procedure to Create and Drop Index
    • Mapplet and Types of Mapplets
    • Defining Reusable Transformations.
    • User Defined Functions
    • Tasks And Types of Tasks
    • Worklet and Types of Worklets
    • Scheduling Work flow
    • Constraint Based Load Ordering
    • Target Load Plan
    • Types of Batch Processing
    • Link conditions
    • Mapping Parameters
    • Mapping Variables
    • Defining Session Parameters
    • Session Recovery
    • Difference Between Normal and Bulk Loading
    • Push Down Optimization
    • PMCMD Utility
    • PMREP Utility
    • Incremental Aggregation

    Module 9: TYPES Of LookUp Caches

    • Static LookUp Cache
    • Dynamic LookUp Cache
    • Persistence lookup Cache
    • Shared LookUp Cache
    • Sorter and Rank Cache

    Module 10: Task Types

    • Session
    • Command
    • EMAIL
    • Timer
    • Event Wait
    • Event Raise
    • Decision
    • Assignment
    • Control
    • Worklet

    Module 11: ETL Testing

    • UNIT Testing
    • System Integration testing
    • PERFORMANCE TESTING
    • ETL Performance Optimization techniques