ETL INFORMATICA REALTIME ONLINE TRAINING,JOB SUPPORT,INTERVIEW SUPPORT,CORPORATE TRAINING BY CORPORATE WORKING FACULTY

FOR Course details and Free Demo contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107

INFORMATICA Course Agenda
(we can customize the course content as per your requirements)

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
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
Informatica Realtime Scenarios

FOR All Details contact :

Phone/WhatsApp : +91-(850) 012-2107
Email : raj@apex-online-it-training.com