Informatica Online Training By Realtime Expert

Friday 25 March 2016

ONLINE INFORMATICA TRAINING



Informatica Online Training | Online Informatica Training


              Informatica online training is completely designed with real time examples and scenarios. The trainer has 14+Years of real time experience worked efficiently on informatica power center tool in different MNC's and in different domains like sales, finance, insurance, quality, banking and hr.

                 Informatica online training provides the flexibility of recording each and every class. Informatica interview questions and answers covered in each class on the same topic. If you don't have time to attend online classes, you have the flexibility to take only videos for all classes. 

                Along with informatica online training, providing following things, which will help you to clear interview and get the job quickly. You can see the Informatica online training demo class video at the end of this page. You can see the comments at the end who already attended the training before you contact me.

  • One Real time Project assignment
  • 200 Informatica Interview Questions And Answers
  • 25 Informatica Real time Scenarios Questions And Answers
  • 150 Oracle-SQL Interview Questions And Answers
  • 150 Unix Interview Questions And Answers
  • 70 Data warehouse Questions And Answers
  • Informatica power center tool installation on your system

Informatica Online Trainer: Venkat 

E-mail: informaticatrainer.expertise@gmail.com

Mobile: 91-8008829289

Duration: 22 Hours 

Informatica Online Training Batches: Week Days/Week ends

Informatica Online Training Course Content

Datawarehousing Concepts

  • Introduction to data warehousing
  • Characteristics of data warehouse
  • How to design a data warehouse
  • Top down and Bottom up approach
  • What is a data mart
  • ETL fundamentals
  • Data Acquisition, Data Merging, Data Cleansing
  • Data Scrubbing, Data Aggregation
  • Dimensional Modeling (Dimensions, Facts)
  • Star Schema
  • Snowflake Schema
  • Slowly Changing Dimensions
Informatica PowerCenter
  • PowerCenter Client Tools
  • PowerCenter Designer
  • PowerCenter Workflow Manager
  • PowerCenter Workflow Monitor
  • PowerCenter Repository Manager
  • Pass-through Mapping
  • Working with source analyzer
  • Working with target  designer
  • Working with mapping designer
  • Working with task developer
  • Working with workflow designer
  • Creating Data Source Names
  • Creating Relational Connections
  • Types of Transformations (Active/Passive)
  • Expression Transformation Usage
  • Aggregator Transformation Usage
  • Filter Transformation Usage
  • Router Transformation Usage
  • Sorter Transformation Usage
  • Rank Transformation Usage
  • Joiner Transformation Usage
  • Union Transformation Usage
  • Lookup Transformation Usage (Connected, Unconnected)
  • Stored procedure Transformation Usage (Connected, Unconnected)
  • Sequence generator Transformation Usage
  • Update Strategy Transformation Usage
  • Source Qualifier Transformation Usage
  • SQL Transformation Usage
Realtime Mappings
  • SCD type-I
  • SCD type-II
Informatica Advanced Concepts
  • Working with flat files
  • Fixed width and Delimited flat files
  • Flat file target example
  • Flat file source example
  • File list (Working With Multiple Files)
  • Transformation Developer Tool
  • How to create a reusable transformation
  • How to use reusable transformation in a mapping
  • Advantages of reusable transformations
  • Mapplet Designer Tool
  • How to create a mapplet (reusable business logic)
  • How to use a mapplets in a mapping
  • Advantages of mapplets
  • Limitations of mapplets
  • Types of Tasks
  • Reusable Tasks
  • Non-reusable Tasks
  • How to work with command task
  • How to work with email task
  • How to work with session task
  • How to work with decision task
  • How to work with link task
  • How to work with timer task
  • How to work with control task
  • How to work with event-wait task
  • Workflows Usage
  • How to create parallel workflows
  • How to create sequential workflows
  • How to schedule workflows
  • Worklets Usage
  • How to create a worklet
  • How to use a worklet in a workflow
  • Nesting of worklets
  • Advantages of worklets
  • Types of Caches
  • Data Cache
  • Index Cache
  • Static Cache
  • Persistent Cache
  • Dynamic Cache
  • Working with predefined functions
  • Performance Tuning
  • How to tune source
  • How to tune target
  • How to tune transformations
  • How to tune session
  • How to tune workflow
Real time Project Assignment
  • Functional Specification Document
  • ETL Technical Specification Document
  • Data Model
You can contact me for 
i)  Online Informatica Training  (or) Informatica Online Training
ii) Only real time project training

200 Informatica Interview Questions And Answers

http://biinformaticainterviewquestions.blogspot.in

25 Informatica Realtime Scenarios

http://datawarehouseinformaticascenarios.blogspot.in

Informatica Performance Tuning

https://www.youtube.com/watch?v=noWePDfRa9c


Please see the below video for  Informatica Online Training DEMO class




16 comments:

  1. I Have taken Informatica power center training,and i'am really impressed by trainer for his teaching methedology .The training was completly focused on real time scenarios.
    Trainer's Knowledge is excellent and he takes classes most of Practical sessions to make us understand how a particular concept implement in projects and the course material is very helpful to crack interviews. Also I will most certainly recommend this training institute to my friends and known people .

    ReplyDelete
  2. the informatica training presentation was very clear.the examples taken were very useful, i learned how to structure in new ways and how to work more effectivley.the sessions taken are used in real time projects. i am so glad i attended, thank you Venkat M.

    ReplyDelete
  3. The training was excellent with step by step along with real time scenarios which helps the non IT folks can also understand very easily. The most I like in venkat is making you the concept implementation based on what requirement's , presentation of the concepts along with examples and given material thus gaining confidence for the trainer in getting the break through for his career

    ReplyDelete
  4. The training was good along with real IT scenarios which helps the understand informatica in good way. His help and guidance help to get me a job break through after long gap in job.

    ReplyDelete
  5. The classes were very good and satisfactory. All the concepts of Informatica were covered. All the real time scenarios explained appropriately. Any questions answered and clarified. Very Explanatory. Above all....flexible hours provided are truly very helpful and supportive to all. Thank you Venkat.

    ReplyDelete
  6. The training was really good. I got real time experience and did hands on practice. His experience gimave me lots of skills and knowledge . Truly satisfy and helpful

    ReplyDelete
  7. This comment has been removed by the author.

    ReplyDelete
  8. The training was really helpful and worth. His experience and scenarios are added advantage to gain more knowledge. Thank you

    ReplyDelete
  9. The training was really helpful and worth. His experience and scenarios are added advantage to gain more knowledge. Thank you

    ReplyDelete
  10. I had recently completed Informatica Powercenter developer training course given by Venkat. He had explained all concepts with minute details and real time examples. I'm completely satisfied with his explanation and course material, its really helpful. Thanks Venkat.

    Regards,
    Shravani

    ReplyDelete
  11. I had recently completed Informatica Powercenter developer training given by Venkat. He had explained every c'm completely satisfied with the explaination and course material. Thanks Venkat.

    Regards,
    Shravani

    ReplyDelete
  12. The presentation was very clear and the examples were relevant.. well presented. The training instills confidence. Thank You Venkat


    Sudhakar

    ReplyDelete
  13. This comment has been removed by the author.

    ReplyDelete
  14. The tainting was very clear and the examples were relevant.. well presented. The training instills confidence. Thank You Venkat.

    Thanks

    ReplyDelete
  15. Very well taught sessions with great real time examples that helped me to understand the things better. I would highly recommend your training to everyone interested in making a career in informatica.

    Thanks a lot.
    -Happy Student

    ReplyDelete
  16. Excellent Training Resource for Informatica. Trainer is having in depth knowledge on informatica projects & explained Real time scenarios with examples & also Completed the training on time as per the course curriculum.

    ReplyDelete