|  |
Online Informatica Training |
Reply to: contact@tekgurukul.com
Date: 10/17/2008 4:45:40 PM
Online Informatica Training is starting from october 26th 2008
Please contact Tekgurukul for two free demo sessions.
Informatica Course Contents
1.Datawarehousing
Datawarehousing concepts
Datawarehousing Architecture
Datamodeling and Multidimensional Modeling
2. Introduction to Informatica
Overview
Basic Definitions
Informatica Products
Informatica Architecture
Tools and their roles
Folders sub folders
Power Center / Power Mart
3. Informatica Designer Introduction
Introduction to designer
Logon to designer
Designer interfaces
Designer tools
Defining Sources
Database as a source
Flat Files as source
Defining Targets
Importing from database
Creating a new target
Creating target database objects
4. Informatica Designer
Mapping Introduction
Source Qualifier
Ports
Mapping- Table to Table
Mapping flat File to Table
Connected/Unconnected Transformations
Active and Passive Transformations
Source Qualifier Transformation
SQL Override-source Qualifier Transformation
Mapping source Qualifier as Filter
Source qualifier to join data
Filter Transformation
Expression Transformation
Sequenced Generator Transformation
Rank Transformation
Router Transformation
Aggregator Transformation
Joiner Transformation
Stored Procedure Transformation (Connected & Unconnected)
Lookup Transformation (Connected & Unconnected)
Transaction control Transformation
Update strategy Transformation
Union Transformation
XML Transformation
Mapping wizards
Implementing Type-I, Type-II, Type-III Mappings
5. Informatica workflow Manager
Workflow Introduction
Tasks
Workflow tools
Connections
Defining tasks
(i) Command Task
(ii) Email Task
(iii) Session Task
(iv) Link Conditions
(v) Decision Task
(vi) Timer Control
(vii) Event Wait & Event Raise
Creating Workflow
Scheduling Workflow
Starting Workflow
Monitoring Workflow
6. Informatica Advances Features
Target Load Plan
Constraint Based Loading
Mapping Parameters
Mapping Variables
Session Parameters
Please contact Tekgurukul for further details.
Contact@tekgurukul.com
559-765-0680
it's NOT ok to contact this poster with services or other commercial interests
|
|
|
| | |
|
