Informatic Online Training | Enrollmytraining

Spread the love

informatica online training

Enrollmytraining provide informatica online training by real time experts in IT industry .We provide informatica online Training in across the World like India,USA, UK, Singapore, UAE, Australia, Europe, Japan, South Africa,Malaysia, Dubai .The student who had taken informatica training got placed in top MNC’s .Student can select regular fast track and weekend batch .We provide informatica online training at your comfortable timing from your home with flexible schedules.

Informatics Online training courses Content:

Data warehouse basics

Data Warehousing Concepts
Different Definitions of data warehouse
Difference between OPERATIONAL DS AND DWH
Types of ETL
Data Extraction
Data Transformation
Data Merging
Data Loading
Types of Data loading
Data Aggregation
ata warehouse Approaches
Top down approach and Bottom up approach
DW Life cycle
DW-database design
Star schema and Snow flake schema
Facts and dimensions
Granuality
Types of Dimensions
Types of fact table
Types of Olap

Informatica Power Center 8.6 Power center Administration

Informatica Power center architecture
Power center components
ETL Plan
Power center Clients
Designer
Workflow manager
Work Flow monitor
Workflow manager
Repository manager
Power center repository
Administrative tool
Repository services
Integration services
Power center domain
Application services
Service manager
Power center administration console

Repository Administration

Creating Repository Users and Groups .
Connecting to the Repository.
Creating a Group
Assigning Privileges to a Group.
Creating a User
Creating a Folder
Folder Permissions
Creating Folders

Using the designer

Creating Repository Users and Groups .
Connecting to the Repository.
Creating a Group
Assigning Privileges to a Group.
Creating a User
Creating a Folder
Folder Permissions
Creating Folders

Transformation Creation

Creating Source Tables.
Creating Target Definitions.
Creating Target Tables
Creating a Pass-Through Mapping
Creating source definitions
Creating a Mapping
Connecting Transformations

Transformation Creation

Using Transformations
Creating a Mapping with Aggregate Values
Active and passive transformations
Creating an Aggregator Transformation
Creating an Expression Transformation
Creating a Lookup Transformation
Connecting the Target
Designer Tips.
Using the Overview Window
Arranging Transformations
Creating the Session
Creating the Workflow
Creating a Mapping with Fact and Dimension Tables
Creating a Filter Transformation
Creating a Sequence Generator Transformation
Creating a Stored Procedure Transformation
Completing the Mapping
Creating a Workflow
Creating a Link Condition.
Running the Workflow

XML sources and Monitoring loads

Using XML Files
Creating the XML Source
Importing the XML Source
Editing the XML Definition
Creating the Target
Creating a Mapping with XML Sources and Targets
Creating an Expression Transformation
Creating Router Transformations
Completing the Mapping
Creating a Workflow
How to monitor loads
Use of Workflow monitor

Using the workflow manager

Connecting Transformations
Creating Sessions and Workflows
Configuring Database Connections in the Workflow Manager
Creating a Reusable Session
Creating a Workflow
Running and Monitoring Workflows
Opening the Workflow Monitor
Running the Workflow

Workflow Tasks

Session
Assignment task
Link task
Event raise task
Event wait task
Timer task
Post session and Pre-session commands
Session recovery
Commit points
Creation of Parameter file
Mapping and session parameter

Performance tuning in ETL

Various optimization technique
Pushdown optimization
Incremental aggregation

informatica online trainingbatch starts at weekend .You can enroll on your flexible timing.

Business analyst ba healthcare online training