Search Courses  in 

Get COURSE FEES Instantly from IBOTS Solutions!


I need details for


My Name

My Mobile Number

My Email ID


IBOTS Solutions

IBOTS Solutions, Hyderabad



Address : Beside Sindhu Travells

S.R Nagar, Hyderabad

Location : S R Nagar - Hyderabad

Postal Code : 500038

Phone :8886396649

Mobile : 9160282194

Toll Free:1800 3000 9533


Landmark : Sindhu Travells

Category : Training Institute

No Ratings0/5

Total Reviews - 0



Bookmark and Share





Online and Classroom
Our teams of experts have more than 7 years of real time consulting experience in the relevant areas. Experienced consultants train and impart practical and theoretical knowledge.

Below are the trainings offered
1. Oracle BI 10g/11g
2.Informatica 8.6
3. Data Warehouse Administration console
4. BI Publisher

Oracle BI 10g/11g: Analytics Overview
Repository Basics
• Building the Physical Layer of a Repository
• Building the Business Model and Mapping Layer of a Repository
• Building the Presentation Layer of a Repository
• Testing and Validating a Repository
• Adding Multiple Logical Table Sources
• Adding Calculations to a Fact
• Creating Dimension Hierarchies and
Level-Based Measures
• Using Aggregates
• Using Partitions and Fragments
• Using Repository Variables
• Modeling Time Series Data
• Modeling Many-to-Many Relationships
• Localizing Oracle BI Metadata
• Localizing Oracle BI Data
• Setting an Implicit Fact Column
• Integrating Third-Party Reporting Tools
• Creating Repositories from Multidimensional Data Sources
• Security
• Cache Management
• Enabling Usage Tracking
• Multi-User Development
• Using Administration Tool Utilities
• Optimizing Query Performance
• Oracle BI Repository Design Principles
Oracle Business Intelligence Answers
• Filtering Requests in Oracle Business Intelligence Answers
• Oracle Business Intelligence Answers: Advanced Features
• Building Views and Charts in Requests
• Showing Results with Gauge Views
• Showing Results with Pivot Table
• Creating Oracle Business Intelligence Interactive Dashboards
• Configuring Oracle Business Intelligence Interactive Dashboards
• Customizing the Oracle Business Intelligence User Interface
• Configuring Guided Navigation Links
• Administering the Oracle Business Intelligence Presentation Catalog
• Using Oracle Business Intelligence Delivers
• Using Oracle Business Intelligence Briefing Books
• Using Oracle BI for Microsoft Office
• Using Oracle Business Intelligence Publisher
• Reviewing Interactive Dashboard
• Design Principles and Best Practices
DAC (Data Warehouse Administration Console)
• Working with Data Warehouse Administration Console
• Populating the Oracle Business Analytics Warehouse
• Configuring the Oracle Business Analytics Warehouse
• Customizing the Oracle Business Analytics Warehouse
• Adding Columns to an Existing Dimension Table
• Adding a New Dimension in OBAW
• Exploring the Change Capture Process
• Scheduling the ETL jobs
• Executing the ETL jobs
• Monitoring the ETL jobs
Informatica 8.6

Introduction to Data Warehousing
What is Data warehousing?
Who needs Data warehouse?
Why Data warehouse is required?
Components of a Data warehouse
Understand Datwarehouse Schema- Star and Snowflake Schema

Introduction to ETL
Components of ETL

Power Center 8.6 Architecture and Components:
Introduction to Informatica Power Center (Data Integration)
Difference between Power Center and Power Mart
Power Center 8.x Architecture
Components of Power Center: Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager.

Informatica 8.6 Power Center Web Administrator Console
Creating the Informatica Repository Server
Connecting the server
Creating Repository
Creating Integration Services

Informatica 8.6 Repository Manager
Creating the Workspace (Folder)
Creating users
Creating user passwords
Creating user groups
Giving privileges to the users, user groups and folders

Overview of Informatica 8.6 Installation
System Requirements
Database Installation and schema creation
Creating Domains and Configurations
Creating Repository
Create a Repository and Integration Service
Creating users and folders

Informatica 8.6 Power Center Designer
Introduction to designer
Designer Interfaces
Designer tools
Connecting to Designer
Components of Designer
Creating Data Source Names
Accessing the source, definations to the designer
Defining Sources
Database as a source
Flat Files sources
Defining Targets
Working with Relational Targets
Working with Flat File Targets
Creating target database objects
Mapping designer
Mapping between the source and target tables
Transformation between source and target tables

Informatica 8.6 Designer – Understand Transformations
What are “Informatica Transformations”
Active and Passive Transformations
Source Qualifier Transformation
Filter Transformation
Expression Transformation
Sequence Generator Transformation
Rank Transformation
Router Transformation
Aggregator Transformation
Joiner Transformation
Stored Procedure Transformation
Mapplet Transformation
Union Transformation
Lookup Transformation: Connected and Unconnected
Reusable Transformations

Understand SCD (Slowly Changing Dimensions)
Implement Type-I mappings
Implement Type-II mappings
Implement Type-III mappings

Informatica 8.6 Workflow Manager
Define Informatica Workflow and why do we need them
How to create a Workflow
Components of a Workflow
Defining Tasks in Workflow
Create a Command Task
Create a Email Task
Create a Session Task and understand different settings
Configure Event Wait & Event Raise Task
Creating Connections
Start Workflow
Monitor Workflow
Understand Session logs
Understand Workflow Logs

Workflow Scheduling: Scheduling Tools
Use Informatica Scheduler
Use 3rd party scheduling tools like Autosys

Performance Tuning in Informatica
Why Performance Tuning
Identify Bottlenecks in Source
Identify Bottlenecks in Targets
Identify Bottlenecks in Transformations
Identify system bottlenecks in Windows
Optimizing strategies for Source, Targets, Mappings and Transformations
Performance of Lookups

Command Line Interface used in Informatica
Overview of PMCMD and functions.
Overview of PMREP and functions.

Informatica Backups and Deployments
Steps to perform the Repository and Database backups
Use Deployment Strategies- Import and Export of Sessions, Workflows, Mappings

Informatica 8.6 Interview Questions
We will provide you bunch of “Most Commonly Asked” Informatica Interview Questions
BI Publisher
• Overview
• BI Publisher Architecture
• Reporting with BI Publisher
• Reporting with Parameters and LOV’s
• BI Publisher secutiry

Thank you

IBOTS Solutions
Achyut Mansion,
Beside Sindu Travels
SR Nagar


List of Training Courses offered by IBOTS Solutions

Informatica ETL
Informatica powercenter

Training Classifieds of IBOTS Solutions

Classified Ads

23-Apr-2012 Obiee real time traininf@ibots solutions
Online and Classroom Our teams of experts have more than 7 years of real time consulting experience in the relevant areas. Experienced consultants train and impart practical and theoretical knowledge. Below are the trainings offered 1. Oracle BI 10g


Unix Academy Delhi Training

High Technologies Solutions - Delhi,Noida,Gurgaon

Embedded Technosolutions Mumbai


GRRAS Institute Ahmedabad Jaipur Pune

Sun Infosystems Surat

Indian Institute of Technocrafts, Kolkata

7 Eleven Arthashastra Chennai

HB Services Adyar Training InstituteITBMS chennai Best Training Institute

Dallas Technologies Bangalore

IIHT Bangalore

JITS Training

Best Oracle PHP Java Training chennaiCareer Innovation Technologies Velachery

IICT Chrompet - SAP Training in ChennaiPMP Training in India

vgit kilpauke learning, e-publishing, technical writting courses

RIA Institute of Technology Bangalore

Mazenet SolutionAMEKS Infotech Ekkattuthangal, Chennai

Core Mind Technologies Chennai

HITS computer Education chennai

Peridot Systems Chennai

IIHT Vadapalani Chennai

Systems Domain Bangalore

Training course fee & Discounts
 Protection Status