Informatica Development Online Training

Informatica Development Course Content:

1.Introduction

  • Data Warehouse / Data Mining / ETL Basics

2.PowerCenter Components and User Interface

  • PowerCenter Architecture
  • SOA and PowerCenter Architecture
  • PowerCenter Client Tools

3.Mapping, Sessions, and Workflow Basics, Transformations

  • Importing Sources and Targets

4.Creating Mappings, Sessions, and Workflows

  • Running the Workflow.
  • Sorter Transformation.

5.Expression, Filter, Router Transformations, and File Lists

  • Sorter Transformation
  • Expression Editor
  • Filter Transformation, File Lists
  • Router Transformation

6.Joins, Features and Techniques

  • Joiner Transformation
  • Merging Data

7.Aggregator, Rank and Sequence generator Transformations and Working with Flat Files

  • Aggregator Transformation
  • Rank Transformations
  • Working with Flat Files
  • Sequence Generator Transformations

8.Union, Joiner, and, Expression Transformations and File Debugger

  • Expression Transformation
  • Union Transformation
  • Joiner Transformation
  • Active and Passive Transformations
  • Data Concatenation

9.Source Qualifier, Stored Procedure, and Transaction Control Transformation

  • Source Qualifier Transformation
  • SQL Overrides
  • Stored procedure Transformation
  • Transaction Control Transformation

10.Lookup (Connected and Unconnected) and Normalizer Transformation

  • Lookup Transformation
  • Lookup Override
  • Connected Lookup
  • Unconnected Lookup
  • Lookup Cache(Static, Dynamic and Persistent)
  • Normalizer

11.Update Strategy Transformation

  • Designing Workflows
  • Workshop about complex Workflows
  • Any clarifications on transformations
  • File Merging
  • Batch Processing
  • Target Load Plan

12.Mapplets, Worklets and More Tasks

  • Worklets
  • Session Parameters
  • Mapping Parameters
  • Mapping Variables

13.Mapping Design

  • Designing Mappings
  • Workshop about mapping designer
  • Slowly Changing Dimensions (SCD)

Course Reviews

No Reviews found for this course.

Drop us a query

Looking for a training for

 Myself My team/organization

captcha

 I agree to be contacted over email

top
Copyright © 2015 KEEN IT TECHNOLOGIES Pvt.Ltd, ALL RIGHTS RESERVED  |   PRIVACY POLICY   |   TERMS OF USE   |   REFUND AND RESCHEDULE POLICIES   |   SITEMAP  
Keen IT is not an affiliate of SAP AG or other products.