Courses Search

(search any course. example: Sap Bw, Java etc.)

Register for a Demo



















helpdesk@sscyient.com    +1 (415)-873 0245

Informatica Online Training

 

Introduction and Architecture

Introduction to Informatica

  • Architecture of Informatica — Power Center 8.1
  • Informatica Design Process
  • Informatica Client Tool — Designer
  • Source Analyzer and Warehouse Designer

Mapping Designer

  • Create a Simple Mapping
  • Overview of Transformations
  • Types of Transformations — Active and Passive
  • Expression Transformation
  • Source Qualifier Transformation
  • Introduction to Workflow Manager
  • Control Flow Statements
  • Task Developer
  • Workflow Designer
  • Creating Connections
  • Flat Files Handling
  • Create Simple Mappings
  • Flat File Analysis

Architecture Review

  • Architecture 8.1 Review
  • Differences between Power Mart and Power Center
  • Connecting to SAP
  • FTP Process
  • Command Task
  • Create a Mapping
  • Joiner Transformation

Transformations

Create a Mapping

  • Using Join in a Source Qualifier Transformation
  • Expression Transformation
  • Filter Transformation
  • Transformations Contd

Multiple Targets Loading

  • Router Transformation
  • Diff between Filter and Router Transformations
  • Create a Mapping
  • Master Outer Join

Transformations Contd

  • Create a Mapping
  • CReusable Transformation
  • CLookup Transformation
  • CDebugger
  • CHandling Multiple Files as Source
  • CMapplets
  • CCreate Mappings
  • CSequence Generator Transformation
  • Multiple Pipelines in a Single Mapping
  • Target Load Plan
  • Mapplets

Update Strategy

  • SCD Type 1 mapping Implementation
  • Update Strategy Transformation
  • SCD Type 2
  • SCD Type 2 mapping Implementation
  • Loading Strategy
  • Sequential and Parallel Loading
  • Union Transformation
  • Dynamic Lookup Cache
  • Introduction to Fact Loading
  • Create a Mapping

Transformations Contd

  • Create a Mapping
  • Date Dimension Loading
  • Lookup Transformation – Persistent Cache
  • Aggregator Transformation
  • Sorter Transformation
  • Creating Stored Procedure

Transformations Contd

    Normalizer Transformation
  • Stored Procedure Transformation
  • Active Vs Passive Transformations
  • Connected Vs Unconnected Transformations

Implementing Incremental Loading

  • Create a Mapping
  • Importance of Mapping Variable
  • Implementing Incremental Aggregation
  • Create a Mapping
  • Incremental Aggregation
  • Transaction and Variable Port
  • Transaction Control Transformation
  • Variable Ports
  • Workflow Tasks
  • Scheduling
  • Task Link Properties
  • Event Raise Task
  • Event Wait Task
  • Work let

Others

Parameter Files

Removing Duplicate Rows

Other Courses
© Copyrights SSCyient 2014. All Rights Reserved. Sitemap