Informatica live online training, job support & interview support by realtime corporate professionals


Informatica coaching causes you to professional in all the concepts relating to integration of heterogeneous data sources and changing the information into helpful info. This tool provides a whole information integration solution and information management system.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


Informatica Interview queries and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments are provided


INFORMATICA COURSE course of study

(As per your needs the course content will be changed):



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


PowerCenter Components
PowerCenter Client Tools
PowerCenter Designer
Workflow Manager
Workflow Monitor
Repository Manager
Excercise1: 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)
Excercise2: Expression Transformation Usage
Excercise3: Aggregator Transformation Usage
Excercise4: Filter Transformation Usage
Excercise5: Router Transformation Usage
Excercise6: Sorter Transformation Usage
Excercise7: Rank Transformation Usage
Excercise8: Joiner Transformation Usage
Excercise9: Union Transformation Usage
Excercise10: Lookup Transformation Usage (Connected, Unconnected)
Excercise11: Stored procedure Transformation Usage (Connected, Unconnected)
Excercise12: Sequence generator Transformation Usage
Excercise13: Update Strategy Transformation Usage
Excercise14: Source Qualifier Transformation Usage
Excercise15: Transactional control Transformation usage


Real time Mappings
SCD type-I
SCD type-II


Working with flat files
How to create flat file as target
How to read flat file data
File list (Working With Multiple Files)


Transformation Developer
How to create a reusable transformation
How to use reusable transformation in a mapping
Advantages of reusable transformations


Mapplet Designer
How to create a mapplet (reusable business logic)
How to use a mapplet in a mapping
Advantages of mapplets


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
How to create reusable tasks
How to create non-reusable tasks


Workflows
How to create parallel workflows
How to create sequential workflows
How to schedule workflows


Worklets
How to create a worklet
How to use a worklet in a workflow
Nesting of worklets


Types of caches
Data Cache
Index Cache
Static Cache
Persistent Cache
Dynamic Cache


Working with functions
Performance Tuning
How to tune source
How to tune target
How to tune transformations
How to tune session
How to tune workflow


Realtime Scenarios