Informatica Training

Informatica Training

Overview:
INFORMATICA is unmistakably a market head in the fields of information coordination and information quality administrations. The INFORMATICA Force Center is an amazing asset to coordinate, oversee and move endeavor information Chairmen with some experience overseeing either Force Center or Information Quality Database engineers and designer Chiefs new to INFORMATICA Force Center

Training Destinations of INFORMATICA:
• Database is nonpartisan and thus can speak with any database
• It is the most impressive information changes instrument and changes over one application's information to another's format.

Target Understudies/Prerequisites:
Essential information on SQL.

Course Contents:

Introduction
Overview
Basic Definitions
INFORMATICA products
INFORMATICA Architecture
Tools and their roles
Folders-Sub folders
Power focus/Force mart

INFORMATICA Creator – Introduction
Introduction to Designer
Logon to Designer
Designer interfaces
Designer Tools
Defining Sources
Database as a source
Flat Document sources
Defining Targets
Importing from database
Creating another target
Creating objective database objects

INFORMATICA Designer
Mapping Introduction
Source Qualifier
Ports
Mapping – Table to Table
Mapping Level Document to Table
Connected/Detached Transformations
Active and Aloof Transformations
Source Qualifier to join Data
Filter Transformation
Expression Transformation
Sequence Generator Transformation
Rank Transformation
Router Transformation
Aggregator Transformation
Joiner Transformation
Stored System Transformation(Connected and Unconnected)
Union Transformation
XML Transformation
Mapping Wizards
Implementing Type-I, Type-II, Type-III Mappings

INFORMATICA – Work process Manager
Workflow Introduction
Tasks
Workflow tools
Connections
Defining tasks
Command Tasks
Email Task
Session Task
Link Conditions
Event Hold up and Occasion Raise
Setting Properties of Meeting Task
Creating Workflow
Starting Workflow
Monitoring Workflow

INFORMATICA Progressed Features
Incremental Aggregation
Map let Implementation
Target Burden Plan
Constraint Based Loading
Mapping Variable
Session Parameters
Link Conditions
Reusable Transformation
Task and Kinds of Tasks
Work let and Kinds of work lets
Scheduling Workflow
Control stream utilizing Direction errand and occasion hold up task
Incremental Loading


cours