Informatica Online Training

Best Informatica Online Training

Informatica Online Training

QTEC provides real-time and placement oriented  Informatica Training online training, online training. 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 online training as soon as you complete the Informatica Training in online training from our institute.

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

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

QTEC provides real-time Informatica Online Training. We Provide 100% Placement Assistance and ensures that each and every student gets all kind of support from us.

Informatica Online 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 Online Training

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


Get Started Now