Krishna Logo
CLICK HERE TO SEE THE LOCATIONS
Divied
Call: Sindhu @ 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 -QA Trai...
Schedule: Sat, 16 Jul 2016
Jul
16
Germantown, MD - Weekend QA...
Schedule: Sat, 13 Aug 2016
Aug
13
BA - Online Weekday
Schedule: Sat, 7 Mar 2015
Mar
07
Ellicott City, MD - Weekend ...
Schedule: Sat, 9 Jul 2016
Jul
09
BA - Herndon Weekend
Schedule: Sat, 9 Jul 2016
Jul
09
Selenium - Online Evening QA...
Schedule: Fri, 11 Mar 2016
Mar
11
Online - Weekday Evening QA ...
Schedule: Mon, 11 Jul 2016
Jul
11
Shadow Bottom
   
© 2005 - 2016 Krishna Training.
Designed & Developed By BitraNet