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

FAQ's



© 2016 ITTRAININGS. All Rights Reserved.|| Made With By Colour Moon