Training Enquiry

Informatica Training


Course Name : Informatica                                                                    24*7 Technical Support
Duration         : 35 hours
Faculty            : Realtime experience

           Sun trainings is a best online center in Hyderabad. We are providing very best online training on Informatica.

Highlights in our training:

*  Very in depth course material with real time scenarios.
*  We are providing class with highly qualified trainer.
*  We will provide class and demo session at student flexible timings.
*  In training case studies and real time scenarios covered.
*  We will give 24*7 technical supports.
*  Each topic coverage with real time solutions.
*  We are providing normal track,weekend,fast track classes.
*  We will give every recorded session for play later.
*  We are giving placement support by multiple consultancies in INDIA, USA, Australia, UK etc.
*  We are providing certification oriented trainings with 100% pass guarantee.
*  We will give full support while attending the interviews and contact me any time after completion of the course.

Course Content:

INTRODUCTION

1. Power Center Components

a) Designer
b) Repository Manager
c) Workflow Manager
d) Workflow Monitor

2. Informatica Concepts and Overview

a) Informatica Architecture.
b) Source Qualifier
c) Target Designer
d) Transformations
e) Mappings
f) Mapplets
g) Sessions
h) Tasks

3. Sources

a) Working with relational Sources
b) Working with Flat Files

4. Targets

a) Working with Relational Targets
b) Working with Flat file Targets

5. Transformations

a) Expression Transformation
b) Lookup Transformation
c) Sequence Generator Transformation
d) Filter Transformation
e) Joiner Transformation
f) Sorter Transformation
g) Procedural Transformation
h) Router Transformation
i) Aggregator Transformation
j) Update Strategy Transformation
k) Union Transformation
L) Rank Transformation
M) Transaction Control Transformation
N) Normalizer Transformation
O) Source Qualifier Transformation
P) Stored Procedure Transformation
Q) XML Source Qualifier Transformation
R) Debugging Mappings

6. ADVANCED INFORMATICA CONCEPTS

a) Unconnected lookup Transformation
b) Mapplet a
d) Defining Reusable Transformations.
e) Tasks And Types of Tasks.
f) Worklet
g) Scheduling Work flow
h) Target Load Plan
i) Types of Batch Processing
j) Link conditions
k) Mapping Parameters
m) Mapping Variables
n) Defining Session Parameters
o) PMCMD Utility

p). TYPES Of LookUp Caches.
a) Static LookUp Cache
b) Dynamic LookUp Cache
c) Perisistance lookup Cache
d) Shared LookUp Cache

7. Task Types:

1 Session
2 Command
3 EMAIL
4 Timer
5 Event Wait
6 Event Raise
7 Decision
8 Assignment
9 Control
10 Worklet

and basics of datawarehousing concepts