Krishna Logo
CLICK HERE TO SEE THE LOCATIONS
Divied
Ria / Kumar @ 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
NEW JERSEY-WEEKEND
Schedule: Sat, 11 Oct 2014
Oct
11
ALPHARETTA-ATLANTA
Schedule: Sat, 25 Oct 2014
Oct
25
AUSTIN-TEXAS-WEEKEND
Schedule: Sat, 4 Oct 2014
Oct
04
IRVING-TX-WEEKEND
Schedule: Sat, 11 Oct 2014
Oct
11
VIRGINIA-QA WEEKEND MORNING
Schedule: Sat, 27 Sep 2014
Sep
27
Online Batch(Weekday Evening...
Schedule: Mon, 20 Oct 2014
Oct
20
ONLINE WEEKEND-QA
Schedule: Mon, 20 Oct 2014
Oct
20
Shadow Bottom
   
© 2005 - 2014 Krishna Training.