Cynosure Knowledge Solutions

A.    Data warehousing:

1.      Data warehousing Concepts
2.      Data Modeling & Multi Dimensional Modeling
3.     Data warehousing Architecture

B.    Introduction to Informatica :

1.    Overview
2.    Informatica Architecture
3.    Informatica Products
4.       Basic Definitions
5.    Folders – sub folders
6.    Tools and their roles
7.    Power Center / Power Mart

C.    Informatica Designer – Introduction :

1.    Introduction to designer
2.    Designer interfaces
3.    Defining Sources
4.    Logon to designer
5.    Designer tools
6     Database as a source
7     Flat Files as source
8     Defining Targets
9     Importing from database
10   Creating a new target
11   Creating target database objects

D.    Informatica Designer :

1.     Mapping Introduction
2.     Source Qualifier
3.     Mapping- Table to Table
4.     Mapping flat File to Table
5.     Ports
6.     SQL Override-source Qualifier Transformation
7.     Rank Transformation
8.     Lookup Transformation (Connected & Unconnected)
9.     Update strategy Transformation
10.    Sequenced Generator Transformation
11.    Source Qualifier Transformation
12.    Transaction control Transformation
13.    Joiner Transformation
14.    Expression Transformation
15.    Connected/Unconnected Transformations
16.    Active and Passive Transformations
17.    Mapping source Qualifier as Filter
18.    Source qualifier to join data
19.    Filter Transformation
20.    Router Transformation
21.    Aggregator Transformation
22.    Stored Procedure Transformation (Connected & Unconnected)
23.    Union Transformation
24.    XML Transformation
25.    Mapping wizards
26.    Implementing Type-I, Type-II, Type-III Mappings

E.    Informatica – Workflow Manager :

1.    Workflow Introduction
2.    Tasks
3.    Connections
4.    Workflow tools
5.    Defining tasks
I.     Command Task
II.    Decision Task
III.   Session Task
IV.    Event Wait & Event Raise
V.     Link Conditions
VI.    Email Task
VII.   Timer Control
6.      Setting Properties of session Task
7.      Starting Workflow
8.      Monitoring Workflow
9.      Scheduling Workflow
10.    Creating Workflow

F.    Informatica Advances Features :

1.    Incremental Aggregation
2.    Mapping Implementation
3.    Constraint Based Loading
4.    Deleting Repository
5.    Copying Repository
6.    Meta Data Backup & Restore
7.    Target Load Plan
8.    Mapping Variables
9.    Mapping Parameters
10.    Session Parameters
11.    Link Conditions
12.    Sending Notification Messages

BENEFITS:

•    Real Time Instructor Led Live Online Training.
•    Customized Courses matching the job requirements of the consultant.
•    Convenience of learning anytime/ anyplace.
•    Feel and decide after a Free Demo with real time instructors working MNC’S.
•    Regular and Crash Courses at the option of the Client.
•    Training with Live Examples.
•    Training Material Support PPT's & Pdf Docs.
•    Practical’s after every major topic.
•    Software access for practice.
•    Round the Clock Support with live-chat facility.
•    Feedback from training coordinators throughout the course.
•    Mock Interviews after the completion of the Course.
•    On the Job Support by the Trainer through Email.
•    All at reasonable Price and payment through a secured payment gateway.