Informatica MDM

 

Master data management (MDM) is a methodology that identifies the most critical information within an organization—and creates a single source of its truth to power business processes.
MDM involves a number of technology solutions, including data integration, data quality, and business process management (BPM).

Pre-requisites for Informatica MDM Online Training

    • Knowledge in SQL
    • Knowledge in RDBMS
    • COURSE CONTNET
    • Introduction to Datawarehousing

      • Data Warehousing Concepts
      • Dataware housing (what/Why/How)
      • Data Modelling(Schemas, FACTS and DIMENSIONS)
      • Slowly Changing Dimensions
      • Metadata
    • PowerCenter Components and User Interface

      • PowerCenter Architecture
      • PowerCenter Client Tools
      • Lab – Using the Designer and Workflow Manager
    • Source Qualifier

      • Source Qualifier Transformation
      • Lab Project Overview
      • Lab A – Load Payment Staging Table
      • Source qualifier Joins
      • Lab B – Load Product Staging Table
      • Source Pipelines
      • Lab C – Load Dealership and Promotions Staging Table and Real time issues
    • Expression, Filter, File Lists and Workflow Scheduler

      • Expression Editor
      • Filter Transformation
      • File Lists
      • Workflow Scheduler
      • Lab – Load the Customer Staging Table and Real time issues
    • Joins, Features and Techniques

      • Joiner Transformation
      • Shortcuts
      • Lab A – Load Sales Transaction Staging Table
      • Lab B – Features and Techniques I and Real time issues
    • Lookups and Reusable Transformations

      • Lookup Transformation
      • Reusable Transformations
      • Lab A – Load Employee Staging Table
      • Lab B – Load Date Staging Table and Real time issues
    • Debugger

      • Debugging Mappings
      • Lab – Using the Debugger
    • Sequence Generator

      • Sequence Generator Transformation
      • Lab – Load Date Dimension Table and Real time issues
    • Lookup Caching, More Features and Techniques

      • Lookup Caching
      • Lab A – Load Promotions Dimension Table
      • Lab B – Features and Techniques II
      • Review and more Lab Activities and Real time issues
    • Router, update Strategy and Overrides

      • Router Transformation
      • Update Strategy Transformation
      • Expression Default Values
      • Source Qualifier Override
      • Target Override
      • Session Task Mapping Overrides
      • Lab – Load Employee Dimension Table and Real time issues
    • Dynamic Lookup and Error Logging

      • Dynamic Lookup
      • Error Logging
      • Lab – Load Customer Dimension Table
    • Unconnected Lookup, Parameters and Variables

        • Unconnected Lookup Transformation
        • System Variables
        • Mapping Parameters and Variables
        • Lab – Load Sales Fact Table
    • Sorter, Aggregator and Self-Join

        • Sorter Transformation
        • Aggregator Transformation
        • Active and Passive Transformations
        • Data Concatenation
        • Self -Join
        • Lab – Reload the Employee Staging Table and Real time issues
    • Mapplets

        • Mapplets
        • Lab – Load Product Daily Aggregate Table
        • Review and more Lab Activities and Real time issues
    • Workflow Variables and Tasks

        • Link Conditions
        • Workflow Variables
        • Assignment Task
        • Decision Task
        • Email Task
        • Lab – Load Product Weekly Aggregate Table
    • More Tasks and Reusability

        • Event Raise Task
        • Event Wait Task
        • Command Task
        • Reusable Tasks
        • Reusable Session Task
        • Reusable Session Configuration
    • Worklets and More Tasks

        • Worklets
        • Timer Task
        • Control Task
        • Lab – Load Inventory Fact Table