Monday, November 26, 2007
 

 

 
 
Non SAP Modules.
 
Abinitio
BOXI
Business Analysis
Business_objects
cognos
Datastage
Dot net
Hyperion Essbase and Analyzer
Informatica 7
Java & J2EE
PL_SQL
QA Whitebox Testing
SIEBEL
SQL
Testing Tools
Tibco
 
    What is AB INITIO?
    AB Initio ETL
    What is ETL?
    Commercial ETL Tools
    Why AB Initio?
    AB Initio Basics
    The Co Operating System
    GDE and the Graphs
    Pipeline Parallelism
    Component Parallelism
    Data Parallelism
    DML
     
  AB Initio Components
   

Input/Output
    Reformat
    Join
    Rollup
    Transform
    Sort
    Partition
    De-partition
    Lookup
    Filter by _Expression
    Gather
    Replicate
    Database Component
   

 
 

Universe Designing Session
     
    Overview
    Creation of Universe
    Connecting to Databases
    Selecting Tables and columns
    Creation of classes
    Creation of  objects
    Joins
    Exercise
    Restricting Data
    List of Values
    Hierarchies
    Resolving Loops
   

Maintenance of Universe
    Fan trap and Chasm trap in Designer
    Row Level and Object Level Security
    Exporting/Importing Universes
    functions
     
 

CMC and Architecture
   

Data Warehousing Overview
   

Business Objects Enterprise Architecture
    Business Objects Enterprise Client Applications
    Business Objects Enterprise Services
    Enterprise Infrastructure
   

Business Objects Enterprise Services
    Business Objects Enterprise Web Services
    Business Objects Enterprise Management Services
    Business Objects Enterprise Storage Services
    Business Objects Enterprise Processing Services
     
 

Security
   

Business Objects Enterprise security model
   

Access levels for content
   

Global and group/user rights
   

Right Inheritance
   

Calculate effective rights
   

Security guidelines
     
 

CCM
   

What is Central Configuration Manager?
   

What can be done in CCM?
     
 

Overview
    What is Central Management Console?
    What can be done using Central Management Console?
   
 

Users and Groups
    Creating Users
     
  Managing Users
    Creating User Groups
   

Managing User Groups
     
 

Folders and Categories 

           
    Creating Folders
    Managing Folders
    Creating Categories
    Managing Categories
     
 

Import Wizard
   

What is Import Wizard?

    Process to use Import Wizard
    Export a Biar File
    Import a Biar File
     
 

Infoview
  Session I
   

What is InfoView

    Logging onto InfoView
    Info View Home Page
    Setting Preferences
     
 

Session II
   

Working with Objects   

    Customization of InfoView by CA
    References  
     
  Web Intelligence and Desktop Intellignce
   

Web Intelligence Overview
   

Creating a New Webi document
   

Restricting data returned by Query
   

Report Design (Formatting Reports covered in this Part)
   

Enhancing Presentation of reports (Creating Formulas and Variables covered in this Part)
   

Analyzing Data
   

CA Standard Templates
     
 

Enhancing the Presentation of Reports
   

Using Breaks, Calculations and Sorts
    Using Report Filters
    Ranking data
    Creating Formulas and Variables
    Using Alerters
    Sections
    Copying data to other Applications
     
  Analyzing Data
   

Scope of Analysis
    Drilling the Reports 
    Setting Drill options
 
Business Analysis Top
     
  Introduction to Business Analysis
    Define the role
    Who Should Attend
    What You'll Learn
     
  Software Development Life Cycle (SDLC)
    Methodologies of SDLC
    Water Fall Method
    Spiral Method
    Extreme Programming
    RAD
    Rational Unified Process (RUP)
    Best Practices
     
  Logical Modeling
   

Business Modeling
    Data Modeling
    Object Oriented Modeling
    Benefits of OO modeling using UML  (Unified Modeling Language)
     
 

Introduction to Object Orientation

   

Classes, objects and actors

    Encapsulation
    Attributes and operations
    Aggregation and composition
    Inheritance
    Association
    Polymorphism
    Using cases and scenarios
     
 

How to Gather and Document User Requirements 

    Capturing Requirements in a Business Requirements Document
   
    Project Vision and Scope
    Identifying Users and Creating a Work Plan
    Types of Requirements
    Documenting User Requirements
    Examples and case study
     
  Use Case Modeling for Business Analysis
    Application of UML in identifying and documenting business processes
    Use Case Overview
    Use Case Diagrams
    Discovering Use Cases
    Completing the Business Analysis  
    Beyond the Analysis Phase
     
 

Case Study
     
 

Introduction to Rational Suite – Case study
   
    Rational Unified Process Modeling
    Rational Rose
    Rational Requisite Pro
    Rational Sode
 
 
Business Objects Top
     
  Datawarehousing
  Datawarehousing Architecture
     
 

Business Objects
   

Desktop Products

    Designer Module
    Supervisor Module
    Supervisor Module
    Business Objects
    Introduction to Designing Universes
    Reporting Requirements
    The Designer Module
    Populating the Structure with Tables
    Joins
    Creating and Testing classes & Objects
    Creating and Testing Measure Objects
    Resolving loops in a Universe
    Contexts and chasm and fan traps
    Restrictions
    Using @ functions
    List of Values
    Hierarchies
    Documenting, Distributing & Maintaining a Universe.
    Linking Universe
     
 

Business Objects with Web intelligence 6.1b (Theory only)
    Introduction to Webintelligence 6
    Getting Started with Infoview
    Viewing Documents in Infoview
    Creating New Documents with Queries
    Restricting Information in different Ways
    Enhancing Report Presentation
    Formatting Reports
    Creating Formulae and Variables.
    Analyzing Data at a Deeper Level
    Sharing Documents
 
COGNOS Top
     
  Datawarehousing
   

Datawarehousing Concepts
    Datawarehousing Architecture
    Data Modeling & Multi Dimensional Modeling
     
  Cognos
   

Introduction to Cognos
    Cognos Tools
    Architecture
    Introduction to Imprompt Administrative
    Defining Connection
    What is a Catalog
    Types of Catalog
    Impromptu Administrator
    Creating a Catalog
    Tables
     Joins
   

Working with Folders
    Creating Folders
    Copying contents
    Calculations
    Conditions
    Prompts
    Generating Reports
    Query Job Overview
    Report Layouts
    Creating Cross-Tab Report
    Creating Group List Report
    Defining Calculations
    Defining Summary Reports
    Conditional Formats
   

Components of a Report
    Custom Report
    Custom Reports
    Creating Template
    Drill Down Reports
    Sub Reports
    Creating PDF/HTML/IQD/Snapshot
    Hot files
    Snapshots
     
  Cognos Web Reporting Architecture
   

Introduction to Web Reporting

    Web Reporting Architecture
    Cognos Web Reporting Components
    Cognos Upfront
    Cognos Query
     
  Introduction to Power Play Transformer
   

Multi Dimensional Model
    Creating Dimensions & Level
    Creating Measure / Types of Measures
    Defining Calculated Source columns
    Generating Categories
    Creating power Cubes
    Creating Custom power Cubes
    Creating cube group
    Generating Reports from Power Cubes
     
  Cognos Report Net.
   

Introduction to Cognos ReportNet

    Architecture
    Framework Manager
    Metadata Modelling
    Package Development
    Package Import & Export
    Query Studio
    Report studio – Basics
    Server Administration Environment
    Reportnet Administration Environment
    Report Studio – Advanced
    Administration
    Security
 
Datastage Top
       
  Datawarehousing
    Datawarehousing Concepts
    Datawarehousing Architecture
       
  Datastage Administrator
    Server properties
    DataStage Project Administration
    Adding Projects
    Deleting Projects
    Cleaning Up Project files
    NLS Configuration
       
  DataStage Director
   

Introduction to DataStage Director
    DataStage Director Window
    Jobs Status view
    DataStage Director Options
     

Limits Page      
      View Page
   

Priority Page
    Running DataStage Jobs
    Validating 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 Links
    Showing CPU Usage
    Stage Status Window
       
  DataStage Designer
   

Importing Table Definitions
    Importing Flat File Definitions
    Designing Server Jobs
    Aggregator Stage
    Transformation Stage
    Annotations
    Annotation Descriptions
    Shared Containers
    Local Containers
    Rejects Rows
    Implementing RouterStage
   

Data Elements
    Routines
    Developing Custom Routines
    Job Sequencer
    Implementing Simple & Complex Jobs
    ORABULX stage
    BCP Load Stage
       
  DataStage Manager
   

Introduction to DataStage Manager 
    Importing Table Definitions
    Importing FaltFile Definitions
    Managing the Meta Data Environment
    Project Export Option
    Project Import Option
 
Dot Net Top
     
  Visual Basic.Net -  Duration: 28 hours
   

The Common Language Runtime (CLR)                                        
    VB.Net Language Overview
    Using VB.Net Data Types
    Expressions and Statements
    Object-Oriented Programming
    Classes and Objects in VB.Net
    Inheritance and Access Modifiers
    Abstract Classes versus Interfaces
    Polymorphism and Virtual Functions 
    Understanding Properties
    Garbage Collection and Object Finalization
   

Working with Strings and Arrays 

    Assemblies and Versioning
    Threading and Synchronization
    Reflection and Attributes
    The power of Delegates and Events
    File I/O and Serialization
    Exception Handling with VB.Net
    Interoperability and Marshaling
    The CLR Collection Classes
    ADO.Net
    XML
     
  C#.Net - Duration: 34 Hours
   

Data Types

    Expressions and Statements
    Exception Handling with C#
    Object-Oriented Programming Primer
    Classes and Objects in C#
    Inheritance and Access Modifiers
    Abstract Classes versus Interfaces
    Polymorphism and Virtual Functions
    Garbage Collection and Object Finalization
    Working with Strings and Arrays
    Using Properties and Indexers
    Threading and Synchronization
    Delegates and Events
    File I/O and Serialization
    Interoperability and Marshaling
    Building apps with Windows Forms
    Working with C# and ADO.Net
    Working with C# and XML
    Working with C# and ASP.Net
    Building Web Services
     
  ASP.Net - Duration: 24 Hours
    Web Forms Design
    HTML Controls and Web Controls
    Input Validators
    Data Binding and ADO.Net
    Session State Management
    Generic Form Templates
    Data Caching and Page Caching
    Understanding XML and SOAP
    Creating Web Services
    Error Handling, Tracing, and Debugging
    Web Security
    XML based Configuration
 
Hyperion Essbase and Analyzer Top
         
  Hyperion Essbase Product Components & Architecture
    Hyperion Essbase OLAP Server
    Hyperion Essbase Application Manager
    Hyperion Essbase Administration Services
    Hyperion Essbase Spreadsheet Add-in
         
  Designing (Multidimensional cubes)
    Essbase Overview
    Designing Outlines (Designing Essbase database structure)
      Creating Applications and Databases
      Identify Business Requirements
      Creating Dimensions and Members
        Essbase Terminology for Dimensions and Hierarchies
        Member Properties
      Designing Time Dimensions
      Designing Accounts Dimensions
      Designing Business View Dimensions
      Designing Calculations(Formulas) in the Outline
      Associate Formulas with Outline Members
      Designing Calculation Scripts (Consolidating and Calculating Data) 
         
  Building: (Implementing Essbase)
    Building Outlines
    Building Load Rules
      Dimensional Building Load Rules
        Loading by Generations
        Loading by Levels
        Loading by Parent-Child
      Data Load Rules
    Building Calculation Scripts
    Loading Data
      Methods for Loading data
      Data Load Parameters
    Executing Calculation Scripts (Perform calculations)
    Preview Data 
         
  Reporting: (custom user interface, ad hoc queries)
    Hyperion Analyzer
      Administration
      Essbase Database connectivity creation
      Building Multidimensional Reports
      Migration (from dev.server to prod.server)
    Spreadsheet Reporting
      Installing Spreadsheet Add-in
      Essbase database connectivity
      Building Reports
         
  Optimizing & Performance in Essbase
    Performance techniques
    Optimizing Calculation Performance
 
Informatica 7.1 Top
     
  Introduction to Informatica
    Overview
    Basic Definitions
    Informatica Products
     Informatica Architecture
    Tools and their roles
    Folders – sub folders
    Power Center / Power Mart
     
  Informatica Designer – Introduction
     Introduction to designer 
    Logon to designer
    Designer interfaces
    Designer tools
    Defining Sources
    (i) Database as a source
    (ii) Flat Files as source
    Defining Targets
    Importing from database
    Creating a new target
    Creating target database objects
     
  Informatica Designer
     Mapping Introduction 
    Source Qualifier
    Ports
    Mapping- Table to Table
    Mapping flat File to Table
    Connected/Unconnected   Transformations
    Active and Passive Transformations
    Source Qualifier Transformation
    SQL Override-source Qualifier Transformation
    Mapping source Qualifier as Filter
    Source qualifier to join data
    Filter Transformation
    Expression Transformation
    Sequenced Generator Transformation
    Rank Transformation
    Router Transformation
    Aggregator Transformation
    Joiner Transformation
    Stored Procedure Transformation (Connected & Unconnected)
    Lookup Transformation (Connected & Unconnected)
    Transaction control Transformation
    Update strategy Transformation
    Union Transformation
    XML Transformation
    Mapping wizards
    Implementing Type-I, Type-II, Type-III Mappings
     
  Informatica – workflow Manager
    Workflow Introduction
    Tasks
    Workflow tools
    Connections
    Defining tasks
    (i) Command Task
(ii) Email Task
(iii) Session Task
(iv) Link Conditions
(v) Decision Task
(vi) Timer Control
(vii) Event Wait & Event Raise
    Setting Properties of session Task
    Creating Workflow
    Scheduling Workflow
    Starting Workflow
    Monitoring Workflow
     
  Informatica Advances Features
    Incremental Aggregation
    Mapping Implementation
    Target Load Plan
    Constraint Based Loading
    Mapping Parameters
    Mapping Variables
    Session Parameters
    Link Conditions
    Meta Data Backup & Restore
    Copying Repository
    Deleting Repository
    Sending Notification Message
 
JAVA & J2EE Top
     
  CORE JAVA
  . Basic & Core Components
   

Features and History
    JVM architecture and BYTECODE
    A Little bit of CODE & Class files
    Data types and Operators
    Control constructs
    Arrays
    String Handling-using String, String Buffer Classes.
    OOPS and OOPS in JAVA
    Classes and Objects
     Methods and Constructors
     Packages and Interfaces
    Access specifiers
    Exception Handling
    Threads and Multithreading
    Wrapper classes, Inner classes
    Applets programming
     
  Java API (The Java Class)
   

‘java.lang’ – Java’s Language Fundamentals
    ‘java.io’ – Java’s I/O Mechanism
    ‘java.util’ – Utilities & Collections Framework.
     ‘java.awt’ – GUI Applications using Java
    java.awt.event’ – Event Handling Mechanism.
    Java.net’ – Socket Programming.
    ‘javax.swing’ – Java’s Extended GUI Programming.
    PageiIinclude, taglib
    Scope
    JSP & JDBC
    JSP & Java Beans – The ‘useBean’ tag
     
  ADVANCED JAVA / J2EE
     
  J2EE Overview:
   

Introduction