Krishna Logo
CLICK HERE TO SEE THE LOCATIONS
Divied
Training details call : Mona / Pooja @ 1-(877) 864-8462

 

Loading
Latest News
Home Navigation Divied
Courses Offered Navigation Divied CONCEPTS how Informatica is used in testing
CONCEPTS How Informatica Is Used In Testing
CONCEPTS How Informatica Is Used In Testing
 
Batch : KT-231
Duration : 1 Month
 

Description:

1Informatica For Testers

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
  • Reusable Transformation
  • Lookup Transformation
  • Debugger
  • Handling Multiple Files as Source

Mapplets

  • Create Mappings
  • Sequence 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
Training Schedules
Irving Tx - Weekend
Schedule: Sat, 11 Jul 2015
Jul
11
Germantown, MD - Weekend
Schedule: Sat, 6 Jun 2015
Jun
06
BA - Online Weekday
Schedule: Mon, 15 Jun 2015
Jun
15
Ellicott City, MD - Weekend
Schedule: Sat, 13 Jun 2015
Jun
13
BA - Herndon Morning
Schedule: Sat, 25 Apr 2015
Apr
25
Selenium - Online Evening
Schedule: Mon, 11 May 2015
May
11
Online - Weekday Evening
Schedule: Mon, 15 Jun 2015
Jun
15
Shadow Bottom
   
© 2005 - 2015 Krishna Training.
Designed & Developed By BitraNet