Informatica Training in Bangalore

Best Informatica Training in Marathahalli, Bangalore

Informatica Training in Bangalore

Prathima Infotech provides real-time and placement oriented  Informatica Training in Marathalli, Bangalore. Our Informatica Training course includes basic to advanced level and our Informatica Training course is designed to get the placement in major MNC companies in Bangalore as soon as you complete the Informatica Training in Bangalore from our institute.

Our Informatica Training in Bangalore trainers are certified in  Informatica Training in Bangalore technology and are experienced working professionals with hands-on real-time  Informatica Training in Bangalore project exposure. We have designed our  Informatica Training in Bangalore course content and syllabus based on students requirement to achieve everyone's career goal. In our  Informatica Training in Marathahalli, Bangalore training program, you will learn all the advanced concepts based on real-time scenarios we provide job oriented  Informatica Training in Bangalore placement training.

Prathima Infotech offers  Informatica Training in Bangalore training with choice of multiple training locations across Bangalore. Our  Informatica Training in Marathahalli, Bangalore training centers are well equipped with advanced lab facilities and excellent infrastructure. We also provide  Informatica Training in Bangalore certification training. Through our associated  Informatica Training in Bangalore training centers, we have trained more than 500+ students and provided placement. Our  Informatica Training in Bangalore training course fee is value for money and tailor-made course fee based on the each student's training requirements.  Informatica Training in Bangalore which provides the training course in Bangalore is flexible to meet students’ needs and conducted on daytime classes, weekend training classes, evening batch classes and fast-track training classes.

Prathima Infotech provides real-time Informatica training in Bangalore. We Provide 100% Placement Assistance and ensures that each and every student gets all kind of support from us.

Informatica Training Course Content


D Datawarehouse Concepts

 

1. Data Warehouse 

2. Data Mart 

3. OLAP VS OLTP 

4. Data Warehouse Architecture (Basic) 

5. Data Warehouse Architecture (with a Staging Area) 

6. Dimensional Modeling 

7. Star Schema 

8. Snowflake Schema 

9. Dimension 

10. Fact 

 11. Slowly Changing Dimension 

 12. Hierarchy 

 13. Confirmed Dimension 

 14. Fact less Fact 

 15. Summary / Aggregations table 

 !6. Change Data capture 

 

E T L Informatica Power Center

 

--> Informatica 8.X and 9.X Versions differences

 

 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 definition

 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 

 b) Lookup 

 c) Sequence Generator 

 d) Filter 

 e) Joiner 

 f) Sorter 

 g) Procedural 

 h) Router 

 i) Aggregator 

 j) Active and Passive Transformations 

 k) Update Strategy 

 l) Data Concatenation 

 m) Debugging Mappings 

 6. Mappings & Mapplets 

 a) Mapping Variables & Parameters 

 b) Creating Cubes & Dimensions 

 c) Working with Mapping Wizards 

 7. Workflow Manger 

 a) Server Architecture 

 b) Workflows, Worklets & Sessions 

 c) Tasks, Assignments, Events, Command etc, 

 8. Performance Tuning 

 a) Informatica Tuning (Source, target, mapping & Session) 

 b) Oracle Tuning (Indexes, MV, Explain plan, Tkprof & SQL Hints) 

 9. Project - Case Study 

 10. Project - Review and Assignment 

Scheduling tool: 

• Informatica Scheduler. 

 

Get the Best Training in Bangalore

Prathima Infotech is Bangalore’s leading training institute with associated training centres across Bangalore. Prathima Infotech has strong network of experienced real time MNC working professionals with sound domain knowledge on multiple training courses to provide job oriented and best course fee using a state-of-art training facilities.


Get Started Now