Informatica Online Training By Realtime Expert

Friday, 25 March 2016


Informatica Online Training | Online Informatica Training

              Informatica online training is completely designed with real time examples and scenarios. The trainer has 9+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 


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

25 Informatica Realtime Scenarios

Informatica Performance Tuning

Please see the below video for  Informatica Online Training DEMO class