Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Saturday, 4 July 2015

Informatica Training online


By on 06:35:00


Informatica Training  


Hello Mates,



1.   Class room training for Informatica 9 will be given for student who located in Chennai, India.


 2.   Informatica 9 Online training will be given for USA students in evening timings.

 3. Informatica 9 training tutorials will be provided at the time of training.


Informatica Training
Informatica Training




1. Introduction

Basic concept of Data warehousing 

Data warehousing Architecture

Data modelling concepts

Star Schema and snow flake schema

ETL process flow

Reporting Process Flow

2. Administration 

Configuring the Repository Server

Starting the Repository Server

Configuring Informatica server

Creating Repository in Administrator Console

Starting the repository

Taking Backup and restoring the repository

Working with Repository Manager

Creating folders, users groups, granting privileges etc..

3. Working with Designer 


Extraction transformation and loading of tables.

Importing and Exporting source and target.

Creating Target tables with constraints.

Creating of simple mapping and complex.

4. Transformations 

Filter Transformations

Router Transformations

Sorter Transformations

Rank Transformations

Expression Transformations

Aggregator Transformations

Source Qualifier Transformations

Joiner Transformations

Union Transformations

Sequence Generator Transformations

Stored Procedure Transformations

Normalizer Transformations

Lookup Transformations

Update Strategy Transformations

Transaction control Transformations

Custom Transformation Transformations


5. Slowly Changing Dimension 

Slowly Changing Dimension Type 1

Slowly Changing Dimension Type 2

Slowly Changing Dimension Type 3

6. Working with Workflow Manager 

Creation of Tasks such as Session,Command and Email.

Working with task developer

Creation of workflow

Creation of Batch session

Running the workflow

Creation of scheduler and configuring the scheduler

7. Working with workflow monitor 

 Monitoring the session and workflow

Troubleshooting the errors

Checking log property

Checking the output with session log

Checking the performance statistics.

8. Cube and Dimensions 

Creating Dimension

Creating cube

Creating mapping for cubes and dimensions

Creating workflow for the cubes and dimensions mapping.


9. Additional concept


Versioning

Debugging

Importing Access,XL files to database

Mapping Parameters & Variables

Session Parameters & Variables

User Defined Functions


Phone - +91-9994883085

Skype - kashif7222

Email - coogle7222@gmail.com

0 comments:

Post a Comment

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)