Informatica:

About Informatica

Informatica is an ETL(Extract,transform,load)and Enterprise Data integration software Tool for building and managing datawarehouse.It has defferent components like power exchange power center,power center conect ,data exchange,power analyzer informatica is a leading data integration software tool.

Overview of informatica training

Sbr trainings one of the best institute for informatica online training in hyderabad come up with New and innovative teaching methodologies to make the learning process easier.The entire course curriculum of informatica designed to meet industry requirements. Flexibility, availability, and conveniences are the three key aspects of our training pattern. Our nline trainingo helps students to learn real time concepts of informatica.the learning process in sbrtrainings is very fun and practical.after completion of the course students will be able to handle live projects.

Informatica Course objectives

A part from general topics candidate will be able to handle special topics such as
• Indepth Understanding Of Informatica
• Use PowerCenter Workflow Manager
• Understand Workflow Task and Job Handling
• Define Technical Architecture of Informatica 9.X
• Informatica Installation and Configuration
• Will be able to handle ETL scenarios and understand functionalities of Repository Management
• Deep knowledge on Informatica Error Handling framework
• Use Session Parameters, Workflow Variables in PowerCenter
• Perform debugging, troubleshooting, Error Handling and Recovery in PowerCenter
• Understand and implement session caches
• Gain insights into Performance Tuning and Optimization
• Understand Informatica Administration Console and Security

Who should go for this course?

Professionals who wants to gain knowledge on informatica
ETL developers
BI professionals
Project managers
Data base Managers
SQL Developers


InformaticaCourse Content:
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

FAQ

1. How does the Online training work and Where do I go to access the online training?
All of our online courses are live instructor-led online courses .Course training is conducted through high-quality online technologies like webex,go to meeting.after registration of the course,access details and link will be given to the students.
2.how much internet speed is required to access online course?
1 mb internet speed is enough To access the online live classes.most of the students are access online training with low internet speed
3.Can I get recorded sessions as a material ?
Yes.we will provide all recorded session which you have done in previous classes on live session .complete practical guide and recorded sessions will be given with material.
4.Can I interact with course instructors?
Yes you can interact with instructors via phone or email to clarify you regarding subject also we provide 24/7 live support to our students.
5. what happen if I miss my training classes?
If any student missed any class.we will provide recorded session as a backup session and if you have any doubts regarding missed session our instructors will clarify on the spot.
6.will I get job assistance?
Yes we will provide job assistance for our students after completion of your course our instructors and career counselors will guide you till the student got placed .
7.is there any discount and offers I can avail?
We will not consider it is a business hence We provide all courses at reasonable prices .you can compare with others.even though our courses are very affordable we will some give discounts on selected courses.
8.who are the trainers?
We have 10+experience ,high qualified and certified trainers with industry expert.they are very knowledgeable in their core domains.
9.can I attend a Demo session?
Yes you can attend our demo session after you enroll the course completely it is free of cost and if you miss the demo we will provide prerecorded demo sessions recorded by our experts our experts
10.what are the payment options?
You can pay by credit card,debit card and net banking from all leading banks,for USD payments,you can pay by PayPal.
11.what if I have more queries?
You can give us a call at +91 9494347041 or email at contact@sbrtrainings.com

Online Informatica Demo Training

Informatica Course Duration

Online Training
It is a 35 to 40 Hours program and extends up to 2hrs each Day.
Corporate Training
It is a 6 days program and extends up to 8hrs each.
Classroom Training
Private Classroom arranged on request and minimum attendies for batch is 4.