Informatica Online Training By Realtime Expert

Friday, 25 March 2016

ONLINE INFORMATICA TRAINING



Welcome to Best Informatica Training

Informatica Trainer: Venkat 

IT Experience: 9+Years on Informatica

Domain Expertise: Sales, Finance, Insurance, Quality, Banking and HR

E-mail: informaticatrainer.expertise@gmail.com

Mobile: 91-8008829289
               91-9886895594

Duration: 22 Hours 

Informatica Online Training Batches: Week Days/Week ends

Salient features Of Informatica Online Training
  • Informatica installation on your system
  • One Real time Project assignment
  • 200 Informatica Interview Questions And Answers
  • 25 Informatica Real time Scenarios
  • Resume preparation and Mock Interviews
Informatica 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


video