INFORMATICA 9.5

This Boot Camp for Developers Informatica Power Center 8.6/9.5 course teaches advanced mapping techniques and performance tuning and provides a thorough review of session partitioning features found in Power Center version 8.6/9.5.

Course Contents

  • Course Introduction
    • 1. Course Objectives
    • 2. Introduction to Informatica Power Center
    • 3. Components & Architecture
  • Designer Overview
    • 1.Interface
    • Tools
  • Live Demo: creating and debugging a mapping

    Concepts

    • Mappings
    • Sources and Targets
    • Transformations Objects
    • Transformation Objects In Depth I
    • Source Qualifier
    • Expression
    • Filter
    • Aggregator
    • Target Instance
    • Lookup
  • Working with Flat Files
    • Importing & editing flat file sources & targets
    • Flat file data-types
  • Using the Debugger
    • Debugging process and strategies
    • Breakpoints, evaluate expressions
  • Designer Tips
    • Documenting objects
    • Context Sensitive Help, Autolink, Link Path
  • Transformation Objects In Depth II
    • Stored Procedure, Router, Sorter
  • Local Variables
    • Using local variables
    • Port evaluation
  • Transformation Objects In Depth III
    • Rank, Joiner
  • Functions
    • Built-In Functions
    • User-Defined Functions
    • Designer: Propagate attributes
  • Sharing and Reusing Designer Objects
    • Reusable transformations
    • Working with shortcuts
  • Transformation Objects In Depth IV
    • Union, Normalizer, Java Transformation, SQL Transformation, HTTP Transformation, Transaction Control
  • Mapplets
    • Designer: Foreign Key Relationships
    • Transformation Objects In Depth V
    • Update Strategy, Sequence Generator
  • Slowly-Changing Dimensions
  • Workflow Manager
    • Menus & tools
    • 5 steps to creating a workflow
    • Session properties
  • Workflow Monitor
    • Interface
    • Controlling workflows and tasks
    • Viewing logs & session properties
    • Gantt Chart View & Task View
  • Workflow Tasks
    • Command, Email, Decision, Timer, Control, Event Raise & Wait
  • Worklets
    Parameters & Variables
    • In mappings
    • In sessions and workflows
    • Parameter files
  • New in 9.5
    • New XConnect for SAP BW 7.0, 7.3
    • New XConnect for custom metadata
    • Rule-based linking
    • Easier to develop and manage: Validation, user-friendly logging
    • Revamped all XConnects for BI and data modeling tools
    • Focused functionality on Operational (Production)
    • Validation scenarios
    • Incremental validation
    • Enhanced reports and dashboards with drill down (Jasper)
    • Single Sign-on
    • Testing across heterogeneous table joins
    • Extending data support
  • More Information
    • Big Transaction Data PowerExchange for Relational, Data Warehousing, Applications
    • New with 9.1:
      PWX for Greenplum
      PWX for MS Dynamics CRM
      PWX for Oracle CDC – Direct to Log
      Support for Exadata: Source/target and repository
    • New with 9.5:
      PWX for SAP: SAP HANA extract/load via ODBC, SAP for BW 7.3
      PWX SQLServer: Datetime2 support, bulk load performance
  • POWEREXCHANGE
    • 1.Power Exchange Data Mover configuration.
    • 2.Installation and configuration of Power Exchange (Navigator and Listener).
    • 3.Setup required for Oracle,Sqlserver and non-relational databases.
    • 4.Creation of Datamaps and Extractation maps,Application map,Registration maps.
    • 5.CDC setup .
    • 6.Continuous and real-time process of CDC.

QUICK ENQUIRY