Data Warehouse Training Institute in Gurgaon

Data Warehouse Informatica is one of the most technology in demand in the India. Live Technoworld provides real-time placement assistance focused data warehousing training in Gurgaon. Our data warehousing course includes basic to advanced level. Our data warehousing trainers are data warehousing certified experts and experienced working professionals with hands on real time multiple Data Warehousing projects knowledge. In our data warehousing training program, you will learn Data warehousing concepts, Datawarehouslng Life cycle, Architecture, Data Modelling, Data Modelling Tools, data warehousing real time project.

Informetica 7.1

1. Introduction to Information
Overview

Basic Definitions

Informetica Products

Informetica Architecture

Tools and their roles

Folders-sub Folders

Power Center I Power Malt

2. Informetica Designer–Introduction
Introduction to designer

Designer interfaces

Designer tools

Defining Sources

(i) Database as a source

(ii) Rat Flies sources

Defining Targets

Importing from database

Creating a new target

Creating target database objects

3. Informetica Designer

Mapping Introduction
Source Qualifier
Ports
Mapping Table to Table
Mapping flat File to Table

Connected/Unconnected Transformations
Active and Passive Transformation
Source Qualifier Transformation
SQL Override-Source Qualifier Transformation
Mapping Source Qualifier as Filter
Source qualifier to join Data
Filter Transformation
Expression Transformation
Sequence Generator Transformation
Rank Transformation
Router Transformation
Aggregator Transformation
Joiner Transformation
Stored procedure Transformation (Connected & Unconnected)
Union Transformation
XML Transformation
Mapping Wizards
Implementing Type-I, Type-II, Type-III
Mappings

4. Informetica – workflow Manager

Workflow Introduction
Tasks
Workflow tools
Connections
Defining tasks

(i)Command Task

(ii)Email Task

(iii)Session Task

(iv)Link Conditions

(v)Event Wait & Event Raise

Setting Properties of Session Task
Creating Workflow
Starting Workflow
Monitoring Workflow

5. Informetica Advanced Features

Incremental Aggregation
Mapplet Implementation
Target Load Plan
Constraint based Loading
Mapping Parameters
Mapping Variables

Reporting tool Cognos or Business Object (BO)

Congos

Report Net with Cognso 8

Architecture
Framework Manager
Metadata Modeling
Package Development
Package Import & Export
Query Studio
Report Studio –Basics
Report Studio -Advanced

Data Stage 7.X

1. Data Stage Administrator

Server Properties
Data Stage Project Administration
Adding Projects
Deleting Projects
Cleaning up Project files
NLS Configuration
Project Expor t Option
Project Import Option

2. Data Stage Director

Introduction to Data Stage Director

Data Stage Director Window
Jobs Status View
Data Stage Director Options
Limits Page
View Page
Priority Page
Running Data Stage Jobs
Validating a Job Running a Job
Stopping a Job
Resetting a Job
Job Scheduling
Deleting a Job
Job Batches
Introduction to Job Batch
Creating a Job Batch
Running a Job Batch
Scheduling a Job Batch
Unscheduling a Job Batch
Monitoring Jobs
The Monitor Window
Showing Unks
Showing (])U Usage
Stage Status Window

3. Data Stage Designer

Importing Table Definitions
Importing Flat Ale Definitions
Designing Server Jobs
Aggregator Stage
Transformation Stage
Annotations
Annotations Descriptions
Shared Containers
Local Containers
Reject Rows
Implementing Router Stage
Data Elements
Routines
Developing Custom Routines
Job Sequencer
Implementing Simple & Complex Jobs

4. Data Stage Manager

Introduction to Data Stage Manager
Importing Table Definitions
Importing Flat File Definitions
Managing the Meta Data Environment

Business Objects (BO)

1. Introduction

Datwarehouse concepts
Difference between Versions 5.x/6/5/XI R1, R2, R3
Business objects XIR3 Suite
Extendibility of Business objects XIR3 (Introduction to BO- SAP Intergration/Dashboard/Xcelsius/Query as Web Service)
Role of Business objects in Data warehousing real time life cycle.

2. Designer

Understanding how universes allow users to query databases using their everyday business terms
Creating an ODBC connection to the course database
Creating a universe
Populating the universe structure
Defining joins in a universe
Understanding classes and objects
Creating classes and objects
Understanding measure objects
Working with LOVs in Designer
Creating a cascading LOV
Resolving loops using aliases
Resolving loops using shortcut joins
Resolving loops using contexts
Resolving chasm traps
Resolving fan traps
Restricting the data returned by objects
Using @ Functions
Working with hierarchies
Using derived tables
Creating links between universes
Setting access restrictions on a universe
Documenting universes
Deploying and maintaining universes

3. Advanced Designer

Use your universe design and Business Objects Universe Designer knowledge to solve Business problems
Define aggregate awareness
Apply aggregate awareness to objects
Combine database functions in objects
Construct relative data-time objects
Create complex predefined conditions
Work with advanced LOVs
Work with advanced join syntaxes
Define connection and user credential parameters
Work with Central Management Server (CMS) universe security
Move content from development to production
Maintain universe design
Work with OLAP universes

4. Designing Topics We can Show by using Following Databases

Oracle
MS-Access
SQL Server
Tera Data
External Files (Flat files)
SAP BW

5. Desktop Intelligence:

Introduction to desktop intelligence
Report Creation
Publishing the report
Report conversation (desktop) to (Webi)

6. Webi Reporting

Accessing information with Web Intelligence
Understanding how universes allow you to query database using everyday business terms
Understanding Web Intelligence core functionalities
Creating a document in the Web Intelligence Rich Client
Viewing a Web Intelligence document in Info View
Building a simple query
Modifying a document query
Working with query properties
Restricting data with query filters
Modifying a query with a predefined query filter
Applying a single-value query filter

Using prompts to restrict data
Using complex filters
Working in the Report Panel
Displaying data in tables and charts
Using breaks and cross tabs
Formatting break, calculations, and report filters
Formatting breaks and cross tabs
Using default and custom sorts
Ranking data to see top or bottom values
Using alerter to highlight information
Organizing a report into sections
Copying data to other applications
Preparing document for PDF and print
Document formatting
Formatting charts
Understanding formulas and variables
Understanding how Web Intelligence calculates data
Creating formulas and variables to calculate data
Adding a new query using a personal data provider
Creating multiples queries in a document
Synchronizing data with merged dimensions
Analyzing the data cube
Drilling into the data
Setting Web Intelligence drill options
Exporting documents from the Rich Client
Accessing Info View
Managing documents in Info View
Scheduling a Web Intelligence document
Setting Info View preference

7. Advanced Webi reporting

Using combined queries
Using sub-queries
Creating a query based on another query
Changing data sources
Understanding the impact of the query drill on performance
Understanding calculation contexts
Redefining calculation context
Using character string functions
Using the replace( ) function
Using the right ( ) function
Using the Substring ( ) function
Using the Pos ( ) function
Using If ( ) to group data
Using data tracking
Using additional report function
Understanding the options for creating hyperlinks in Web Intelligence
Creating hyperlinks in the different Web Intelligence interfaces

8. Webi rich client

Web Intelligence Rich Client general preferences
To create a new document in Web Intelligence Rich Client without Universe
To select a universe in Web Intelligence Rich Client
How does Web Intelligence generate combined queries?
Scope of analysis
Levels of scope of analysis
To set the scope analysis

9. Query as Web service

Usage of Query as web service
How to configure and use
Viewing the Universe and Webi reports using web service
Viewing the Crystal XCelsius reports using web service

10. Introduction to Dashboard Creating Dashboards Contents

What is Dashboard Builder?
Creating an Analytic based on a Universe Query
Creating a Corporate Dashboards folder
Creating a pie chart based on sales of product lines Saving your pie chart
Creating a bubble chart that compares product line sales to Revenue
Scheduling an Analytic RefreshScheduling a refresh on your bubble chart

Designing a Corporate Dashboard a text analytic to the dashboard
Creating a speedometer gauge that shows profit margins
Creating a dashboard tab that contains analytics
Creating a dashboard sub tab with web page and viewer analytics

11. Data source Migration

Migrating reports and data sources
Migration options
Modifying the migration setting

12. Import Wizard / Report Conversation

Using Import wizard
Creating of BIAR
Migrating the BO objects from one CMS to another CMS
Migrating the objects from one domain to another (dev/stage/Prod)

13. Publishing

Publish the Webi report between different CMS
Publish the converted reports (deski to webi) to destination servers
Publishing the repository objects

14. CMC/CCM/CMS

Introduction of Window and web based Central management in BOXIR3
Roles and responsibilities of Contents of CCM/CMS/CMC
When to use CCM/CMS/CMC
Detail description of contents of CCM/CMS/CMC
Case study

15. BO-SAP INTEGRATION

Understanding common interfaces between BOXIR3 and SAP
Installation and Integration methods
Bring the SAP environment in to BOXIR3 and vice versa
Working with SAP objects in Crystal 2008 (Info cubes/SAP Table)

16. Crystal Report 2008

Introduction to Crystal Reports
Creating Reports
Selecting Records
Organizing Data on Reports
Formatting & Section Formatting
Creating basic and complex formulas
Using Variables and Arrays
Using Report Templates
Applying Conditional Reporting
Building parameterized and specialized reports
Summarizing Data with Cross Tabs
Using Report Sections
Representing Data Visually
Managing Reports
Distributing Reports
Using Repository and Repository data sources
Report Processing
Using sub Reports
Using Custom Functions
How to Publish Crystal Report in Bo-Enterprise Portal
Scheduling

17. CRYSTAL XCELSIUS

Understanding crystal xcelsius
Creating templates
Building query template in xcelsius
Creating scorecard and dashboard using xcelsius

18. BO-VOYAGER

Understanding Voyager
Creation of personal and corporate voyager
Publishing the voyager
Importing cubes in voyager & Report Development

19. Bo-Administration

Computer setup
Business Objects Enterprise Architecture
Creating Folders, Users and groups
Publishing and configuring the servers
Scheduling

Office Address

M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana

Branch Office

M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana

Call Now

9968523574, 8588809802,
0124-4077100

Email us

website

Office Address

M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana

Call Now

9968523574, 8588809802,
0124-4077100

Data Warehouse Training Institute in Gurgaon

Informetica 7.1

1. Introduction to Information Overview Basic Definitions Informetica Products Informetica Architecture Tools and their roles Folders-sub Folders Power Center I Power Malt

2. Informetica Designer–Introduction Introduction to designer Designer interfaces Designer tools Defining Sources (i) Database as a source (ii) Rat Flies sources Defining Targets Importing from database Creating a new target Creating target database objects

3. Informetica Designer

4. Informetica – workflow Manager

5. Informetica Advanced Features

Reporting tool Cognos or Business Object (BO)

Congos

Report Net with Cognso 8

Data Stage 7.X

1. Data Stage Administrator

2. Data Stage Director

3. Data Stage Designer

4. Data Stage Manager

Business Objects (BO)

1. Introduction

2. Designer

3. Advanced Designer

4. Designing Topics We can Show by using Following Databases

5. Desktop Intelligence:

6. Webi Reporting

7. Advanced Webi reporting

8. Webi rich client

9. Query as Web service

10. Introduction to Dashboard Creating Dashboards Contents

11. Data source Migration

12. Import Wizard / Report Conversation

13. Publishing

14. CMC/CCM/CMS

15. BO-SAP INTEGRATION

16. Crystal Report 2008

17. CRYSTAL XCELSIUS

18. BO-VOYAGER

19. Bo-Administration

Office Address

Branch Office

Call Now

Email us

website

Office Address

Call Now

Email us

website

1. Introduction to Information
Overview

Basic Definitions

Informetica Products

Informetica Architecture

Tools and their roles

Folders-sub Folders

Power Center I Power Malt

2. Informetica Designer–Introduction
Introduction to designer

Designer interfaces

Designer tools

Defining Sources

(i) Database as a source

(ii) Rat Flies sources

Defining Targets

Importing from database

Creating a new target

Creating target database objects