Microstrategy Online Training| OBIEE Online Training| Informatica Online Training| Cognos Online Training| SAP FICO Online Training

Monstercourses.com is the leading and pioneers in online training, provides online training on all IT technologies by industry qualified experts
online training classes on all Information technologies by IT industry experts, one free demo will be given, course material will be provided along with the training,software will be installed by our admin person, our online training classes will be held by hands on trainers.Our online training courses are informatica online training, cognos online training,

Monstercourses.com providing online training on informatica, cognos online training, obiee online training, microstrategy online training ,datastage online training, teradata online training, BOXI online training, SAP fico online training, bo, abap online training, BOXI online training, oracle dba, sql/pl , dot net online training, asp.net, C#.net, JAVA online training, QA Etc..

Inspired faculty
Hands on trainers
Material will be provided
software willl be installed
Resume guidance will be given
One free demo will be given before sign up for the course
Affordable price
Quality online training
Placement assistance will be provided
online training by experienced trainers
software will be provided
online training will be held through goto meeting and webex
Live interactive online training classes
MonsterCourses is an IT Online Training Organization. Our strengths are our technical Industry experts in making diverse technologies work together and our commitment to maintain high service standards in Training.

MonsterCourses.com teaching methodology is different and unique as the training programs designed helps the Learners to master in broad range of skills that is essential to become a creative IT professional.  We have dedicated trainers who continuously work to improve quality of Online Training programs.

Learners who complete Graduation, Post Graduation and working employs were not adequately trained to meet today’s World of competition. So there was a great need for highly professional online training institute and in order to fill this gap MonsterCourses.com was started.

We at MonsterCourses.com believe that the best Trainer is one who teaches his Learner with his own experience rather than from a book.  Trainers at our organization works their level best in providing quality Online Training to our Learners


Join http://www.monstercourses.com for better career Opportunities


Pl call us on +1 772 777 1557

Monstercourses.com is having fully qualified and industry experts who can teach quality online training to the students,
our online training classes includes datawarehousing, sap, oracle, microsoft technologies, JAVA. J2ee, core java, testing tools, androied etc.

DATASTAGE Online Training @ monstercourses

COURSE NAME :  DATA STAGE Online Training COURSE DURATION :  40 HOURS

STEP-1 DATA WAREHOUSE FUNDAMENTALS An Introduction of Data warehousing purpose of Data warehouse Data ware Architecture OLTP Vs Data warehouse Applications Data Marts Data warehouse Lifecycle SDLC

STEP-2 DATA MODELING Introduction of Data Modeling Entity Relationship Model Dimensions and Fast Tables Logical Modeling Physical Modeling Schemas Like Star Schema & Snowflake Schemas Fact less Fact Tables

STEP-3 PROCESS OF ETL (EXTRACTION, TRANSACTION @LOAD) Introduction of Extraction , Transformation and Loding Types of ETL tools Key tools in the market

STEP-4 INSTALLATION PROCESS Windows server Oracle .NET Datastage 7.5X2 & 8x

STEP-5 DIFFERENCE Server jobs & Parallel jobs

STEP-6 COMPONENTS IN DATASTAGE Administrator clint Designer client Director client Import/export manager Multi client manager Console for IBM imformation server Web console for IBM imformation server

STEP-7 INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X Datastage Introduction IBM Information server Architecture IBM Data Quality Architecture EnterpriseInformation Integration Web Sphere DataStage Components

STEP-8 DATASTAGE DESIGNER About Web Sphere DataStage Designer Partitioning Methods Partitioning Techniques Designer Canvas Central Storage Job Designing Creating the Jobs Compiling and Run the Jobs Exporting and importing the jobs Parameter passing System(SMP) & Cluster system(MPP) Importing Method(Flat file, Txt, Xls and Database files) OSHImporting Method Configuration file

STEP-9 PARALLEL PALETTE DATABASES STAGES Oracle Database Dynamic RDBMS ODBC SQL Server Teradata FILE STAGES Sequential File Dataset Lookup File set DEV/DEBUG STAGES Peek Head Tail Row Generator Column Generator PROCESSING STAGES Slowly changing dimension stage Slowly changing dimensions implementation Aggregator Copy Compress Expand Filter Modify Sort Switch Lookup Join Marge Change Capture Change Apply Compare Difference Funnel Remove Duplicate Surrogate Key Generator Pivot stage Transformer

CONTANERS Shared Containers Local Containers

STEP-10 DS-DIRECTOR About DS Director Validation Scheduling Status View logs Monitoring Suppress and Demote the Warnings Peek view

STEP-11 DATASTAGE ADMINISTRATOR Create Project Delete Project Protect Project Environmental variables Auto purge RCP OSH Commands Execute Multiple Instances Job Sequence Settings

STEP-12 JOB SEQUENCE AREA Job Activity Job sequencer Start loop Activity End loop Activity Notification Activity Terminator Activity Nested Condition Activity Exception handling Activity Execute Command Activity Wait for file Activity User variable Activity Adding Check Points Restartable

STEP-13 IBM WEB SPHERE QUALITY STAGE Data Quality Data Quality Stages Investigate Stage Standardize Stage Match Frequency Stage Reference Match Stage Unduplicated Match Stage Survive Stage Viewing audit details in operational DASHBOARD reports

KEY SERVICE FAQS Covering DBA concepts Concentration on performance tuning Real time scenarios Certification guidance Resume preparation Sample resumes Interview & certification FAQS How to face the interview Class notes which is useful for who is trying for job Project preparation Visit : www.monstercourses.com

Cognos 10 Online Training

 COGNOS 10 Online Training

What is Cognos ?

Cognos is a developer of business intelligence software. They are one of the largest suppliers of business intelligence tools, globally, and the name is recognized as a leader in their field of BI reporting.

Cognos was found in the late ’60s in Ontario but is now part of the IBM group, as they were acquired by IBM in 2008 and are now part of their business analytic division.

While Cognos provide a whole suite of business intelligence reporting software and tools, their name has become synonymous with OLAP, (Online Analytical Processing).

BI tools are used in many organizations and for various tasks including

To implement a Cognos solution, a consultant would most likely be assigned to your organization to undertake an analysis of your current operational systems and to determine the most effective implementation of an intelligence analysis system.

COGNOS 10.2 online training

COGNOS Business Intelligence Training

Introduction to data warehousing.

Introduction to Cognos online training

Introduction to the Reporting Application

Describe IBM Cognos BI components

IBM Cognos Report Studio: Author Professional Reports Fundamentals

Examine Report Studio and its interface

Explore different report types

Create a simple, sorted, and formatted report

Explore how data items are added to queries

Create List Reports

Format, group, and sort list reports

Describe options for aggregating data

Create a multi-fact query

Create a report with repeated data

Focus Reports Using Filters

Create filters to narrow the focus of reports

Examine detail and summary filters

Determine when to apply filters on aggregate data

Create Crosstab Reports

Format and sort crosstab reports

Convert a list to a crosstab

Create complex crosstabs using drag and drop functionality

Create crosstabs using unrelated data items

Present Data Graphically

Create charts containing peer and nested items

Add context to charts

Create and reuse custom chart palettes

Present key data in a single dashboard report

Focus Reports Using Prompts

Identify various prompt types

Use parameters and prompts to focus data

Search for prompt items

Customize prompts to facilitate users’ choices

Navigate between pages

Display users’ prompt selections in the report

Extend Reports Using Calculations

Create calculations based on data in the data source

Add run-time information to the reports

Create expressions using functions

Use Additional Report Building Techniques

Reuse objects within the same report

Share layout components among separate reports

Discuss report templates

Add pages to a report

Choose options to handle reports with no available data

Customize Reports with Conditional Formatting

Create multi-lingual reports

Highlight exceptional data

Show and hide data

conditionally render objects in reports

Drill-Through From One Report to Another

Let users navigate from a specific report to a target report

Pass parameter values to filter the data in drill-through targets

Drill-through Definitions

Parameter-driven drill through

Steps to enable drill-through access for a package

Drill Through Assistant

Enhance Report Layout

Force page breaks in reports

Modify existing report structures

Apply horizontal formatting

Specify print options for PDF reports

Combine data containers displaying data from different queries

Format data and report objects

IBM Cognos Report Studio: Author Professional Reports Advanced

Create Query Models

Build query models and then connect them to the report layout

Add filters and prompts to a report using the query model

Edit an SQL statement to author custom queries

Create Query Reports Based on Relationships

Create reports by merging query results

Create reports by joining queries

Combine data containers based on relationships from different queries

Create query containers containing a single data value

Distribute Reports Through Bursting

Distribute reports using bursting

create burst keys

Identify report recipients and data items using burst tables

Distribute reports using email and IBM Cognos Connection

Design Effective Prompts

Control report displays using prompts

Specify conditional formatting values using prompts

Create a report that formats based on prompts selection

Create a sorted and filtered report based on prompt selection

Enhance User Interaction with HTML

Create tooltips that clarify report data

Create a popup window that contains prompts

Send emails using links in a report

Create Additional Advanced Reports

Create a report that displays summarized data before detailed data

Highlight alternate rows in a list report

Create a report using an external data file

Use single data items to summarize report information

Examine the Report Specification

Examine the report specification structure

Save and edit reports locally

Discuss considerations for modifying a report specification

IBM Cognos Report Studio: Author Active Reports

Introduction to IBM Cognos Active Reports

Discuss the value of active reports

Examine an active report and its controls

Convert an existing report to an active report

Debug and save an active report

Explore interactive properties

Use Filter and Select in Active Reports

Distinguish between filter and select

Examine decks and cards

Explore properties to use in active reports

Examine master-detail relationships and decks

Use Advanced Features with Active Reports

Drill through on an active report

Drill up an down on an active report

Create cascading prompts in an active report

Query studio:

Types of reports

Query studio templates

User interface

Operation on list report

Data formatting

Expand and collapse group

Custom groups

Filters and calculations

Conditional formatting

Analysis studio:

Introduction to analysis studio

Types of analysis

Rows columns and context

Suppress zeros and nulls

Filters and calculations

Top and bottom rows

Sorting

Drill up and drill down

Convert to chart

Replacing columns and rows

Open in report studio

Event studio:

Benefits of event studio

Process flow

Specify event condition

Tasks

Task execution rules

Agents

Scheduling an agent

Framework Manager

IBM Cognos Framework Manager: Design Metadata Models

Create a Baseline Project

Examine the IBM Cognos BI and Framework Manager workflow processes

Define a project and its structure

Describe the Framework Manager environment

Create a baseline project

Enhance the model with additional metadata

Prepare Reusable Metadata

Verify relationships and query item properties

Ensure efficient filters by configuring prompt properties

Calculations and Filters

Use calculations to create commonly-needed query items for authors

Use static filters to reduce the data returned

Use macros and parameters in calculations and filters to dynamically control the data

Returned

Specify Determinants

Use determinants to specify multiple levels of granularity and prevent double-counting

Create the Presentation View

Identify the dimensions associated with a fact table

Identify conformed vs. non-conformed dimensions

Create star schema groupings to provide authors with logical groupings of query subjects

Work with Different Query Subject Types

Identify key differences and recommendations for using data source, model, and stored

Procedure query subjects

Identify the effects on generated SQL when modifying query subjects, SQL settings and

Relationships

Set Security in Framework Manager

Examine the IBM Cognos BI security environment

Restrict access to packages

Create and apply security filters

Restrict access to objects in the model

Create Analysis Objects

Apply dimensional information to relational Metadata to enable OLAP-style queries

Sort members for presentation and predictability

Advanced Generated SQL Concepts and Complex Queries

Governors that affect SQL generation

Stitch query SQL

Conformed and non-conformed dimensions in generated SQL

Multi-fact/multi-grain stitch query SQL

Variances in Report Studio generated SQL

Dimensionally modeled relational SQL generation

Cross join SQL

Various results sets for multi-fact queries

Use Advanced Parameterization Techniques in Framework Manger

Identify session and model parameters

Leverage session, model, and custom parameters

Create prompt macros

Leverage macro functions associated with security

Model Maintenance and Extensibility

Perform basic maintenance and management on a model

Remap metadata to another source

Import and link a second data source

Run scripts to automate or update a model

View lineage

Create a model report

Optimize and Tune Framework Manager Models

Identify and implement techniques to optimize and tune your Framework Manager

models

Work in a Multi-Modeler Environment

Implement repository control

Segment and link a project

Branch a project and merge results

Manage OLAP Data Sources

Connect to an OLAP data source (cube) in a Framework Manager project

Publish an OLAP model

Publish a model with multiple OLAP data sources

Publish a model with an OLAP data source and a relational data source

Manage Framework Manager Packages

Specify package languages and function sets

Control model versioning

Nest packages

IBM Cognos BI Administration

Describe IBM Cognos architecture at a high level

Define IBM Cognos groups and roles

Explain how to extend IBM Cognos BI

Introduction to IBM Cognos BI Administration

Describe the role of the Administrator in relation to the IBM Cognos BI administration

Workflow process.

Describe the role of IBM Cognos Administration and IBM Cognos Configuration user

interface components

Identify IBM Cognos BI Architecture

Identify features of the IBM Cognos BI architecture

Identify an example of Cognos BI request processing

Performance planning and installation options and configurations

Perform IBM Cognos BI on a single machine

Secure the IBM Cognos BI Environment

Identify the IBM Cognos BI security model

Define authentication and authorization in IBM Cognos BI.

Identify security policies

Secure administrative capabilities (access to functionality)

Specify security settings after installation.

Implement security in IBM Cognos Framework Manager and IBM Cognos Transformer

Administer the IBM Cognos BI Server Environment

Overview of administrative tasks that can be performed in IBM Cognos Administration

Monitor system metrics

Manage dispatchers and services

Tune server performance

Identify issues while troubleshooting the server environment

Formulate the IBM Cognos BI backup strategy

Manage Run Activities

Manage current, past, and upcoming run activities

Manage schedules

Manage Content in IBM Cognos Administration

Add and manage a data source

Distribute data and create a distribution list and contacts

Deploy IBM Cognos BI content

Maintain the IBM Cognos BI content store

Customize the appearance of IBM Cognos BI

Visit : www.monstercourses.com 

Informatica online training @ monstercourses

Course Name          :  Informatica Online Training

Course Duration  : 30 Hours

Introduction to Datawarehousing Informatica training

Introduction and Architecture

• 1.1 Architecture and Software Overview
• 1.2 ETL and ELT Architecture Overview
• 1.3 Partitioning and Parallelism Introduction
• 1.4 PowerCenter Services RAM Utilization
• 1.5 Differences Between 32 bit and 64 bit

Client Software Overview

• 2.1 Introduction to Designer Interface
• 2.2 Introduction to Workflow Manager Interface
• 2.3 Introduction to Workflow Monitor
• 2.4 Introduction to Repository Manager
• 2.5 Nature of ODBC in the Designer
• 2.6 Software Demonstration

Source Object Definitions

• 3.1 Flat File Sources
• 3.2 Relational Sources
• 3.3 Data Previewer
• 3.4 Metadata Extensions
• 3.5 LAB: Import a Source

Target Object Definitions

• 4.1 Target Definitions
• 4.2 Target Properties
• 4.3 Flat File Targets
• 4.4 Relational Targets
• 4.5 LAB: Import a Target

Mappings

• 5.1 Defining a Data Flow Diagram
• 5.2 Transformation Objects and Views
• 5.3 Source Definition and Source Qualifier
• 5.4 Pre-SQL and Post-SQL Rules
• 5.5 Expression Transformation
• 5.6 Informatica Functions
• 5.7 Variable Ports
• 5.8 Data Types
• 5.9 Mapping Validation
• 5.10 LAB: Create a Working Mapping

Workflows

• 6.1 Workflow Tools
• 6.2 Workflow Structure
• 6.3 Workflow Connections
• 6.4 Workflow Tasks
• 6.5 Workflow Design Process
• 6.6 Workflow Properties
• 6.7 Workflow Links
• 6.8 Session Tasks
• 6.9 LAB: Configure a Workflow and Session

Monitoring Workflows

• 7.1 Workflow Monitor Views
• 7.2 Monitoring a Server
• 7.3 Actions Initiated from the Workflow Monitor
• 7.4 Filtering Views
• 7.5 Truncating Monitor Logs
• 7.6 Stop Versus Abort
• 7.7 LAB: Run and Monitor the Workflow
• 7.8 LAB: Demonstration of Designer Features

Debugger

• 8.1 Debugger Features
• 8.2 Debugger Windows and Indicators
• 8.3 Debugger Best Practices
• 8.4 LAB: Debug the Mapping

Filter Transformation

• 9.1 Filter Functionality
• 9.2 Filter Properties
• 9.3 Filter Versus DB Where Clause
• 9.4 LAB: Create a Filter Transformation, Run Workflow

Sorter Transformation

• 10.1 Sorter Functionality
• 10.2 Sorter Properties
• 10.3 Sorter Versus Database Order by Clause

Aggregator Transformation

• 11.1 Aggregator Transformation
• 11.2 Aggregator Expressions and Functions
• 11.3 Using Unsorted and Sorted Data
• 11.4 Data Flow Rules
• 11.5 Aggregator Versus Database Group By

Joiner Transformation

• 12.1 Homogeneous and Heterogeneous Joins
• 12.2 Joiner Conditions and Properties
• 12.3 Joiner Usage
• 12.4 Nested Joins
• 12.5 Joiner Versus Database Join
• 12.6 LAB: Add Sorter, Joiner, and Aggregator

Lookup Transformation

• 13.1 Lookup Principles
• 13.2 Lookup Properties
• 13.3 Lookup Caching
• 13.4 Lookup Versus Database Join
• 13.5 LAB: Create a Basic Lookup

Target Options

• 14.1 Target Properties
• 14.2 WHERE Clause
• 14.3 Constraint-Based Loading
• 14.4 Target SQL Override Best Practices

Update Strategy Transformation

• 15.1 Update Strategy Transformation
• 15.2 Update Strategy Expressions
• 15.3 Update Strategy Best Practices
• 15.4 LAB: Create a Type 2 Dimension Update

Router Transformation

• 16.1 Router Functionality
• 16.2 Router Groups
• 16.3 LAB: Use a Router to Delete Rows
• 16.4 LAB: Data Driven Versus Session Switches

Parameters and Variables

• 17.1 Parameter Scoping
• 17.2 System Variables
• 17.3 Mapping Parameters and Variables
• 17.4 Variable Functions

Unconnected Lookups

• 18.1 Usage and Techniques
• 18.2 Advantages
• 18.3 Functionality
• 18.4 Conditional Lookups
• 18.5 LAB: Create an Unconnected Lookup

Heterogeneous Targets

• 19.1 Heterogeneous Target Types
• 19.2 Target Type Limitations and Conversions
• 19.3 LAB: Build Heterogeneous Targets

Mapplets

• 20.1 Mapplet Designer
• 20.2 Mapplet Advantages
• 20.3 Mapplet Types and Rules
• 20.4 Active and Passive Mapplets
• 20.5 Mapplet Parameters and Variables
• 20.6 Mapplet Designer Best Practices
• 20.7 LAB: Build a Mapplet

Reusable Transformations

• 21.1 Transformation Developer
• 21.2 Rules
• 21.3 Promoting and Copying Transformations
• 21.4 Transformation Developer Best Practices
• 21.5 LAB: Create and Use a Reusable Transformation

Sequence Generator Transformation

• 22.1 Sequence Generator Functionality
• 22.2 Sequence Generator Properties
• 22.3 Sequence Generator Best Practices
• 22.4 LAB: Create a Variable Based Sequence Generator

Error Logging

• 23.1 Setting On and Off
• 23.2 Data Rejects with Error Logging Off
• 23.3 Error Logging to Database Table and Flat File
• 23.4 Source Row Logging
• 23.5 Error Logging Best Practice Architecture

Workflow Configuration

• 24.1 Server Connections
• 24.2 Reusable Workflow Schedules
• 24.3 Reusable Session Configurations
• 24.4 LAB: Create a Sequential Workflow
• 24.5 LAB: Create a Concurrent Workflow

Reusable Tasks

• 25.1 The Command Task
• 25.2 The Email Task
• 25.3 Reusable Task Best Practices

Non-Reusable Tasks

• 26.1 The Decision Task
• 26.2 The Assignment Task
• 26.3 The Timer Task
• 26.4 The Control Task
• 26.5 The Event Wait Task
• 26.6 The Event Raise Task
• 26.7 Non-Reusable Tasks Best Practices
• 26.8 LAB: Create Event Wait/Event Raise and Timer
• 26.9 LAB: Create a Control and Assignment Task
• 26.10 LAB: Create a Command Line Task

Worklets

• 27.1 Reusable Worklet
• 27.2 Non-Reusable Worklet
• 27.3 Worklet Best Practices