Dataware Housing

Ab-initio

Abinitio Course Contents

1.          Introduction to Abinitio
2.          Abinitio Architecture
3.          Graph  Programming
4.          Introduction to .dat and .dml files
5.          Partition Components
a.          Braod Cast
b.          Partition by Expression
c.          partition by range
d.          partition by community
e.          partition by percentage
f.          partition by Round Robin

6.      Departition Components

a.          Concatenate
b.          Gather
c.          Interleave
d.          Merge

7.          Multifile System(MFS)

8.          Types of parallelism

9.      Layouts

10.     Sort Components
a.          Sort
b.          Sort with in groups
c.          Sample
d.          Partition by key and sort

9.      Transform Components

a.          Filter by expression
b.          Aggregate
c.          Scan
d.          Rollup
e.          Denormalize Sorted
f.          Normalize
g.          Reformat
h.          Match sorted
i.           Dedup sorted

11.     Working with Databases

 

12.     Database components
a.          Run SQL
b.          Input Table
c.          Output Table
d.          Truncate Table
e.          Update table

13.     Phase and check Points

14.     Miscellaneous component
a.          Gather logs
b.          Run program
c.          Redefine format
d.          Trash
e.          Replicate

15.     Dataset Components
a.          Input File
b.          Output File
c.          Lookup File
d.          Intermediate File

16.     FTP Components
a.          FTP From
b.          FTP To

17.     Compress Components
a.          Compress
b.          Uncompress
c.          Gzip
d.          Gunzip

18.     Validate Component
a.          Check Order
b.          Generate Records
c.          Generate Random bytes
d.          Compare Records
e.          Compute Check Sum
f.          Compare Check Sum

19.     Translate components
a.          Record XML
b.          Write XML

20.     Project and Sandbox

21.        Performance Tuning

 

Bussiness Analytics

Introduction - What is Business Analysis?
A look at different viewpoints
What is being analyzed?
What’s the goal?
Current trends in business analysis
Key concepts
Definition
Reconciled to common understanding within the organization

The Role of the BA
The relationship of business analysis to project management
Differentiating between business analysis and other “analyst” roles
Customer Needs & IT Needs
The Skill Set Of A BA
The BA’s Core Knowledge Set

The Practice of Business Analysis
BA Responsibilities
Requirements Shepherding
Analysis Workflow
Dark Side Of Business Analysis
What The BA Does Not Do!
Exercise: What Are Your Challenges?

The Landscape of Requirements
Requirements, Features And Constraints
Types Of Requirements – Functional & Non-funtional
Requirements Source, Audience And Approval

Business Requirements

  • Establishing Project Vision And Scope
    Unified Process Vision Documentation
    The Vision Document Problem Statement
    Example: Problem Statement
    Exercise Case Study: Business Requirements
    Exercise: Create A Problem Statement
    Documenting Project Scope
    Example: Scope Statement
    Group Discussion: The Offshore Challenge
  • Software Development Methodologies
  • SDLC
    Water Fall Model
    Spiral Methodology
    Agile (more evolved, RAD session: reverse-engineer session)
    RUP (Rational Unified Process)
    Example Case Study
  • Diagnosing the Business Environment
  • Business problem solving
    Understanding the business environment
    Capturing business initiatives across the enterprise
    Diagnosing a business problem or opportunity (i.e.; business initiative)
    Definition of a problem
    Finding and verifying true causes
    The use of the problem statement
    Techniques to identify business problems and causes
    Workflow modeling
    Fishbone Diagrams
    IS—IS NOT analysis
    Example Case Study
    Obtaining stakeholder confirmation
  • Setting Goals for Business Initiatives
  • Using problem statement to create the goal statement
    Quantifying goals – finding the “threshold of pain”
    Key characteristics of well-stated goal statements
    Uses the language of the business
    Is measurable
    Is clear
    Is relevant to the overall strategy of the organization
    An examination of poorly stated goals
  • Evaluating, Selecting, and Prioritizing Initiatives
  • Employing analysis techniques to assess alternatives
    Using a weighted-decision model
    Obtaining stakeholder confirmation


Steps in the Project/Product Lifecycle: Description, Duration, Deliverables
Conduct preliminary study
Gather requirements
Generate alternative solutions
Complete the design
Create the solution
Implement the solution
Evaluate and maintain the solution
Positioning business analysis (and the business analyst) within the project life cycle
Examining the role of the BA prior to project initiation (Diagnosing the business environment)
Group Exercise: Business Requirements Challenge



Documenting the Project Scope
How to determine the product scope
Outcome oriented development
Defining product objectives
Creating solution prototypes
Working backwards to create the solution
Specifying critical project elements and deliverables

Building a Model of the Solution
Developing output mockups or prototypes
Identifying requirements
Creating an information model
Workflow diagrams – How to use MS - Visio
Uses in the project life-cycle
Current State (As Is)
Future State (To Be)
Establishing solution boundaries
Constructing context, overview, and detail flow diagrams
Identifying appropriate detail level
Example Case Study
Supporting documentation
Business rules
Data requirements
Use Case analysis
Confirming with stakeholders

Requirements Definition and Documentation
Identifying internal and external stakeholders
Conducting stakeholder analysis
Selecting requirements development templates
Producing a requirements development plan
elicitation
analysis
specification
verification and validation
change management
Addressing common challenges
Recognizing industry standards (IEEE, etc.)
Analysis of Requirements
Fact gathering methods
Interviewing
Observation
Questionnaires
Research
Organizing the facts
Determining requirements
Estimating the useful life of the solution
Calculating future requirements
Imposing constraints using value engineering
Establishing the concept of a solution
Managing Requirements
All Users Are Not Equal - User Attributes
Assigning User Attributes
Example: User Attributes
Exercise: Identify User Attributes
User Surrogates
When Requirements Collide: Alternative Decision-Making
Approaches
How Requirements become Un-Managed
Requirements Traceability & Change Control
BA’s role in managing change
An examination of why people resist change
Recognizing symptoms of resistance
Developing coping/diffusing tactics
Group Exercise: Change Control
Interviewing Techniques
Preparation
Stakeholder Analysis
Planning the interview
The art of questioning
Role of the interviewer - building confidence
The psychology of interviewing
Group Exercise: Project Improvement Facilitation

Introduction to Project Documents
Project Plan/GANTT Chart
Quality Plan
MS Excel Spreadsheets
Business Requirements Document
Technical Design Document
Example Case Study: Review of Project Documents

Introduction to SQL, Use Case Modeling & Unified Modeling Language (UML)
SQL – Basic & Advanced
What is a Use Case?
System
Basic Flow, Alternate Flows & Exception Flows
How Use Case Diagrams Show Relationships
The Use Case Template
Paths and Scenarios
Use Case Diagrams
Class Diagrams
Sequence Diagrams
Activity Diagrams
Introduction to Rational Suite
Rational Rose
Rational Requisite Pro
Rational Clear Case
Example Case Study: Use Case Review
Group Exercise: Develop A Class Diagram

Making the Business Case
Using creativity to create alternate solutions
Evaluating alternatives to determine feasibility
The six factors of feasibility: TRELOS
Technical: is it possible?
Risk
Weighing risks vs. benefits
Using the portfolio approach
Economic
Developing cost estimates
Calculating the return on investment
Legal: is it against the law?
Operational: will it work for us?
Schedule: can we deliver it in time?

Communicating the Solution to Stakeholders
The proposal structure
Analysis of current strengths and weaknesses
Objectives to be achieved
Description of solution
Alternatives for implementation
Explanation of recommended solutions
Costs and risks
Schedule (task plan) to achieve benefits
Supporting appendices
Preparing and making the presentation
Establishing your objective
Doing audience analysis
Organizing your ideas
Using visuals
Rehearsing

Supporting Downstream Development
Quality Assurance and Testing
The business analyst's role in testing
Objectives
Requirements
Types of tests
Use Case vs. Test Case
Key to successful tests - anticipation and reconciliation
Procedures
The need
A successful style - play script
Who has responsibility
Training
Key to user independence
Intended results
Time required
Who performs it

Evaluation
How can the solution be evaluated?
When?
Who should perform an assessment?
Establishing ranges of performance
Eliminating undesirable side-effects

Positioning the Business Analyst within the Organization
Job Title or role?
Organization Structure
Reporting Relationships
Working Relationships
Tailoring the business analyst role for different projects
Getting Started

The Offshore Chal
Project Management Challenges
Challenges For The Business Analyst

Project
For Student Assignment & Evaluation

Miscellaneous
BA Resume Prep
Interview Questions & Preparation

 

BO XI
Data warehousing/Dimensional
modeling Practical Concepts
OLTP vs. OLAP
Types of OLAP
Dimensional modeling
Data mart/Data warehouse Life cycle
Star/Snow/Extended Star schema design
Database Concepts needed for Data warehousing
Joins & Cardinality
Views/Materialized Views
Date/Time Functions
Conversion functions
Package
Derived table & Stored Procedure
BOXIR3 Architecture
Architectural overview
Client tier components
Application tier components
Intelligence tier
Processing tier
Data tier
Security management
Information flow
Universe Design
Understanding Business Objects Universes
Creating the Course Universe
Building the Universe Structure
Creating Dimension Objects
Creating Measure Objects
Resolving Loops in a Universe
Resolving SQL Traps
Using List of Values
Applying Restrictions on Objects
Using @Functions with Objects
Using Hierarchies
Deriving Tables & Indexes
Working with Aggregate Awareness
Designing Advanced Objects
Creating Predefined Condition
LOVs & Joins
Securing Universes
Implementing Universe Life Cycle  Mgmt
Maintaining & Optimizing Universes
Creating Universe from Other Data sources
Web intelligence
Understand concepts of Web intelligence
Create Web Intelligence documents with Queries
Restrict data returned by a query
Design a report
Enhance the presentation of data in reports
Format a report
Calculate data with formulas and variables
Use multiple data sources
Analyze data
Manage and share Web Intelligence documents
Work with Advanced Query techniques
Work with calculation contexts
Create formulas with character & date string functions
Use "If" logic
Work with additional reporting techniques
Create hyperlinks
Crystal Reports
Planning a Report
Selecting Records
Formatting a Report
Representing Data Visually
Distributing Reports
Creating Basic Formulas
Organizing Data on a Report
Applying Section Formatting
Applying Conditional Reporting
Using the Repository
Using Report Templates
Creating Formulas
Building Parameterized Reports
Summarizing Data with Cross-Tabs
Using Report Sections
Managing Reports
Presenting Data Visually
Add hyperlinks to a report
Dashboard Builder
Understanding Dashboard Manager
Setting Up Dashboard Manager
Creating Metrics
Automating Dashboards with Rules
Creating Analytics
Creating Personal Dashboards
Creating Corporate Dashboards
Guiding Dashboard Navigation
Xcelsius-Scorecard Builder
Creating a Model
Adding Interactivity to a Model
Creating a Connected Model
Connect to Crystal Reports data and create Dashboard
Connect to Web intelligence report data and
Create Dashboard
Connect to Business Objects Universes
Using Query as a web service and create Dashboard
Use Live Office data and create Dashboard
Use other connectivity components and create Dashboard
Migration from BO5.X to BOXIR3
Migration fundamentals
How Business Objects Enterprise XI 3.0
Compares with versions 5.x and 6.x
Migration concepts
Import Wizard Concepts
Understanding object migration
Understanding user and group migration
Migration planning and assessment
After migration with the Import Wizard
Administration
Understand the Business Objects
Enterprise interface & architecture
Manage Business Objects Enterprise content
Secure Business Objects Enterprise content
Secure application security
Schedule content
Publish reports
Identify Business Objects Enterprise architecture
Perform common server management tasks
Manage the Business Objects Enterprise servers
Widgets
Installing BI Widgets
Using BI Widgets to Access BI Content
Working with widgets
BI Widgets Content Authoring Guidelines
Auto refresh of Widgets
Desktop Intelligence
Introduction to desktop intelligence
Scope of analysis
ZABO
Report creation
Saving the reports in local repository
Publishing the report
Report conversion (desktop) to (Webi)
Webi-rich Client
Installing Web Intelligence Rich Client
Web Intelligence Rich Client working modes
Launching Web Intelligence Rich Client
To set user preferences in Web Intelligence Rich Client
Working with documents
Working with universes in Web Intelligence Rich Client
Accessing Web Intelligence from InfoView
Working with queries in Web Intelligence Rich Client
Working with reports
Universe Builder & Query Builder
Universe Builder basics
Building universes from XML metadata sources
Updating XML metadata source universes
Exporting a universe to a XML file format
Query as Web service
Configuring the QWS with BO System
Creating Webservice report from Universes
Creating WSDL reports
Using WSDL reports in external application
Voyager
Getting Started with Business Objects Voyager
Using Queries to Analyze Cube Data
Using Charts to Visualize Data
Selecting Members to Display in Crosstabs and Charts
Sorting, Filtering, and Ranking Data
Highlighting Exceptions in Data
Saving and Sharing Voyager Workspaces
Security Implementation
Creating Secured users & group
Creation secured connections
Creation of Secured objects
Creation of security at Table, Column &row level
Creation of secured restriction set and mapping to users or groups
OLAP Universe
Creation of OLAP Universe by connecting to an Info cube
Updating the OLAP Universe (Cube)
Creating the Custom Hierarchies in OLAP Universes.
Accessing multiple info cubes to create an OLAP Universe
Import Wizard\Publishing Wizard
Using Import wizard
Creation of BIAR
Migrating the BO objects
From one CMS TO ANOTHER CMS
Migrating the objects from one
domain to another (dev/stage/Prod)
Backup & Maintenance Deployment
Business View Manager
Creation of Semantic layer for Crystal reports
Creation of Dynamic list of values in Crystal reports
Creation of Cascading list of values in Crystal reports
Creating Data connection and Dynamic data connection
Creation of Data foundation
Creation of Business Element
Creation of Business View
Creation of LOV
Saving the Business view to repository
Accessing the Business View in Crystal reports using Database expert
Creation of Crystal reports using Business
View
Performance Management
Creation of Metric Universe
Creation of Metrics & Analytics
Creation of Dashboard using Metric
Creating Performance dashboards using set analysis
Live Office Reporting
Describe the benefits of using Live Office
Connect to the repository
Navigate the Live Office menu
Insert charts, crosstabs, and fields from a Crystal report
Insert report parts from a Web Intelligence document
Insert a new query based on a Universe
Insert Live Office objects into an email
Navigate and refresh Live Office objects
Enable consolidated prompts
Set refresh settings for objects
Set parameter binding
Take a snapshot
Save Live Office documents to the repository
Open and view Live Office documents from the repository
BO-SAP Integration/Edge Series
Understanding BO-SAP Integration kit
Configuring single sign on authentication
Creating SAP Authentication in BO
Importing the roles of SAP into BO
Entitlement settings of SAP & BO System
SAP Webi/Dashboard Reporting:
Creation of Web intelligence reports using Info cube & BW Query
Introduction to BO-SDK
Introduction of BO Enterprise SDK
Choosing the right SDK
Customizing the Webi reports using SDK
Introduction to BO Extension points:
How to use & Leverage BO Extension points in Business Objects
Comparison of all BO Versions (5.x/6.5/XIR1/XIR2/XIR3)
Architecture changes
Report creation charges
Universe level changes
Security level changes
Addition of new features
Performance Tuning of Database w.r.t BO
BO Query tuning
BO Execution plan/Tracing
Combined Query
Views/Derived tables
Performance Tuning of BO
Universe Tuning
Webi report Tuning
Database Tuning
Deployment methods
Crystal reports tuning
BO Query optimization & Customization
Installation of BOXIR3 suite with System/Audit/Performance mgmt repositories using Oracle/SQLSERVER/SAPBW
BO installation with Oracle
BO installation with SQL Server
BO installation with MYSQL
BO installation with SAPBW
Testing & Migration of BO components from Dev/Stage/Production environment
Migrating the BO objects to Stage & Production
Testing the BO Reports using TOAD Developer
Creating LDAP Security model for migration
Polestar/Business Explorer
Creating Polestar Reports
Configuring Pole star with BO System
BO XI R3 Certification Guidelines:
Sample questions on Business Objects Certified Professional – Business Objects Web Intelligence XI 3.0 – Level One
Sample questions on Business Objects Certified Professional – Business Objects Web Intelligence XI 3.0 –Level two

 

Cognos

COGNOS INTRODUCTION

  • Introduction to Cognos
  • Introduction about Cognos other products
  • Introduction to Cognos 7
  • Cognos 8 Architecture

REPORT STUDIO

  • Creating Cross-Tab Report
  • Creating Group List Report
  • Conditional Formatting in RS
  • Applying Page braking in RS
  • Creation of master detail Reports in RS
  • How to use conditional blocks and layout component reference
  • Creating Complex Reports using set operators
  • Variables creation and usage
  • Sorting of report, prompt,
  • Creation of different type of prompts list prompt, text prompt, date prompt, time prompt, date and time prompt,

COGNOS FRAMEWORK MANAGER

  • Creation of Data Source Connection for database and Power play cube
  • Creation of project,
  • Query subjects
  • Creation of Query subjects
  • Joins
  • Working with Folders,
  • Creating Folders
  • Creation of Packages, Publishing Packages
  • Creation of IQD Files
  • Security in FWM

QUERY STUDIO

  • Creating Cross-Tab Report
  • Creating Group List Report
  • Conditional Formatting in QS
  • Applying Page braking in QS
  • Custom Groups creation in Qs
  • Difference between master detail report and drill through report
  • Creation of filters and grouping filters
  • Report Layouts
  • Creation Drill through reports in RS, QS
  • Drill down/Drill up Report
  • Sorting of report, prompt,
  • Formatting Reports

COGNOS REPORT NET VS COGNOS 8
COGNOS CONNECTION

  • Portal Customization
  • Writing test cases for reports and report testing and validation
  • Deploying from one environment to another environment single report Deployment, multiple report Deployment
  • Single report Scheduling and jobs creating for scheduling multiple reports
  • Connecting Report to another Package

 

 
Cognos TM1

Examine TM1 Components

  • Review financial performance management
  • Identify the TM1 user community
  • Describe the components of TM1

Configure a TM1 server

  • Define a TM1 server
  • Create a configuration file
  • Identify the basic tasks required to create a TM1 application and deploy it

Create Dimensions

  • Review cubes and dimensions
  • Create dimensions manually
  • Create dimensions using Turbo Integrator

Build Cubes and Views

  • Discuss cubes and data points
  • Create cubes
  • Construct views of data in cubes

Load and Maintain Data

  • Identify data sources
  • Create processes to load data
  • Create a process to delete data in a cube
  • Create processes to update and maintain the model

Add Business Rules

  • Discuss a rule
  • Construct rules for elements or consolidations
  • Use functions in rules
  • Optimize rule performance

Automate Common Processes Using Scripts

  • Review Advanced tabs in Turbo Integrator
  • Load custom data into a cube
  • Add a subset to a dimension
  • Use logic in scripts
  • Export data to ASCII
  • Move data between versions
  • Construct chores

Customize Drill Paths

  • View related data
  • Create a Drill Process
  • Create a Drill Assignment Rule
  • Edit a drill process

Manage the Server

  • Broadcast messages to clients
  • Connect and disconnect users from a TM1 server
  • Shut down a remote TM1 server

Browse Data in a Cube

  • List the components of a cube
  • Create a new view of the data
  • Stack, swap and filter dimensions in a cube
  • Use drill capabilities to focus the data

Focus Your Analysis using Subsets

  • Examine the benefits of subsets
  • Use aliases in subsets
  • Filter subsets
  • Differentiate between static subsets and dynamic subsets

Contribute Data

  • Spread data to multiple cells at once
  • Edit individual cells
  • Exclude cells from being adjusted

Work with Spreadsheets

  • Differentiate between a slice and a snapshot
  • Use a classic slice and an Active Form
  • Manage TM1 data through Excel

Work with Spreadsheets

  • Create interactive reports and data input templates using Active Forms
  • Customize Active Forms using new TM1 Functions
  • Apply formatting to Active Forms

Create Dynamic Reports with Active Forms

  • Create interactive reports and data input templates using Active Forms
  • Customize Active Forms using new TM1 Functions
  • Apply formatting to Active Forms

Implement TM1 Security

  • Identify TM1 authentication options
  • Create users and groups
  • Assign object security rights to groups

Integrate with IBM Cognos 8 BI

  • Integrate TM1 cubes within a Cognos 8 Business Intelligence (BI) environment
  • Integrate IBM Cognos TM1 in Cognos 8 BI portals

 

DataStage
  • Data Warehouse Concepts
  • Job Properties and Parameters
  • Containers
  • Job Sequence
  • DataStage Director
  • Troubleshooting DataStage Jobs
  • DataStage Idioms
  • Development Best Practice & Standard
  • Performance Tuning Techniques
  • Implementation Strategy
  • DataStage Version Control Concepts & Applications (Release 7.5)
  • DataStage Release 7.5 Applicable Features
  • DataStage Stage structure & components
  • Types of Data Sources & Targets
  • Using DataStage Manager
  • Hashed Tables & Reference Table Look-up
  • Handling Multiple Sources & Targets
  • Aggregation Stage
  • Sort Stage
  • Transformer Stage

 

 

Data stage with xml

Course Content:
Module I: Introduction on data stage

  • brief history of data stage
  • where does data stage fits with in data ware housing contest?
  • What is IBM information server 8.0 and Web Sphere data stage?
  • Where web sphere data stage packs fit with in the IBM Information server architecture
  • various versions available
  • Introduction to data stage server components
    • Repository
    • Data stage server
    • Data stage package installer
  • Introduction to data stage client components
    • Data stage administrator
    • Data stage designer
    • Data stage director
    • Data stage manager (removed in latest version)

IBM web sphere data stage and quality stage designer overview

  • How to connect to a project
  • The designer A quick tour
  • IBM information server repository
  • Developing a job
  • Introduction to job properties
  • Introduction to job parameters
  • Introduction to table definitions
  • Importing and exporting from the repository
  • Report assistance and documentation tools
  • Configuration files editor.

Module III: Web Sphere Data Stage Server Jobs:
Introduction to server jobs
handling databases in server jobs
handling databases in server jobs

  • Handling special characters (#and$)
  • Loading tables.
  • Data type conversion- writing to oracle
  • Data type conversion- reading from oracle
  • Looking up on oracle table
  • Updating on oracle table
  • ODBC Stage
  • Universe stage
  • Handling files in server jobs
  • Sequential file stage
    • How to use sequential file stage
    • Defining sequential file input data
    • Defining sequential file output data
    • How the sequential stage behaves
    • Folder stages
  • Handling processing stages in server jobs
  • Transformer stage
    • How to use transformer stage
    • Transformer editor components
    • The data stage expression editor
    • Transformer stage properties
    • Overview of transformer function
    • Using transformer as a look up stage
  • Aggregator stage
    • How to use aggregator stage
    • Defining the input colomn sort order
    • Aggregating data
  • Merge stage
  • Sort stage

Parallel processing in data stage
Infrastructure as a foundation for data warehousing

  • various hardware and the operating systems available
  • What are the various platform option
  • Client server architecture for data warehouse
    • Various server hardware available
    • SMP (symmetric multiprocessing)
    • Clusters
    • MPP ( massively parallel processing)
    • CCNUMA OR NUMA(cache-coherent non – Uniform memory architecture)

Types of parallel processing in data stage

  • pipeline parallelism
  • partition parallelism
  • Combining pipeline and partition parallelism
  • Repartitioning data
  • Parallel processing environments
  • The configuration file

Types of partitioning in data stage

  • round robin
  • random
  • same
  • entire
  • hash by field
  • modulus
  • range
  • DB2
  • Auto

`
Type of collecting in data stage

  • • round robin
  • • ordered
  • • sorted merge
  • • auto
  • The mechanics of partitioning and collecting

Web sphere data stage parallel jobs

  • introduction to data stage parallel jobs
  • difference between a passive stage and active stage
  • handling metadata in data stage
    • Running column propagation (RPC)
    • Table definitions
    • Schema files and partial schemas
    • Data types
    • Data and time formats
    • Complex data types

·  Handling oracle enterprise stage in parallel jobs

  • handling special characters(# and $)
  • loading tables
  • type conversions writing to oracle
  • updating an oracle database
  • deleting rows from an oracle database
  • leading an oracle database
  • reading an oracle database
  • performing a direct lookup on an oracle database table
  • using SQL builder

Handling transformer stage in parallel jobs

  • how it is different from server transformer stage
  • creating and deleting columns
  • handling null values
  • defining constraints and handling otherwise links
  • specifying link order
  • defining local stage variables
  • what is a BASIC transformer stage
  • transformer functions

? combining data in data stage parallel jobs

  • horizontal and vertical combining
  • join stage
    • inner
    • Left outer
    • Right outer
    • Full order
  • Look up stage
  • Merger stage
  • Comparison between join merge and look up stage
  • Partitioning in reference links
  • Aggregator stage
  • Funnel stage
    • Funnel mode
    • Sort funnel mode
    • Sequence

Some more useful stages in data stage parallel jobs

    • sort stage
      • sequential sort
      • Parallel sort
      • Total sort
      • Partitioning requirement
    • Remove duplicates stage
    • Modify stage
      • Dropping and keeping columns
      • Changing data type
      • Null handling
    • Pivot stage
      • Limitations in pivot stage
      • Modify stage
      • Copy stage
      • Filter stage
      • External filter stage
      • Switch stage
      • Compress stage
      • Expand stage
      • Encode stage
      • Decode stage
      • FIP enterprise stage
      • Generic stage
      • Surrogate key generator stage
      • SAS stage

Capturing changes in data stage parallel jobs

    • change capture stage
    • Change apply stage
    • Difference stage
    • Compare stage
    • Slowly changing dimension stage

Handling develop / debug stages in data stage parallel jobs

    • Head stage
      • Head stage
      • Head stage default behavior
      • Skipping data
    • Tail stage
    • Sample stage
    • Peek stage
    • Row generator stage
      • How to specify data to be generated
      • Generating data in parallel

Colomn generator stage
Write range map stage

      • How to perform range look up in data stage
      • handling restructure stages in data stage parallel jobs
        • colomn import stage
        • Colomn export stage
        • Make sub record stage
      • Split sub record stage
        • Combine records stage
        • Promote sub record stage
        • Make vector stage
        • Split vector stage

Handling XML file in data stage parallel jobs

        • Introduction to XML files
        • Using the XML meta data importer
        • Using xml input stage
          • Validating documents and schemas
          • Processing namespaces
          • Supported x path expressions

Using XML output stage

        • Processing names spaces
        • Supported x path expressions
        • Aggregating input rows on output
        • Writing output to your file system
        • Processing NULLS and empty values
        • How repetition paths work

Using xml transformer stage

        • Optimizing performance in server and parallel jobs

Web sphere data stage jobs and processes
interpreting performances statistics in server jobs
improving performance in server jobs

        • CPU limited jobs single processor systems
        • CPU limited jobs multiprocessor systems
        • I/O limited jobs
        • Hashed file stages
        • Hash file design

Inter process stages in sever jobs
Link collector stages in server jobs
Link partitioned stages in server jobs
Job design tips in parallel jobs

        • Processing large volumes of data
        • Modular development
        • Designing for good performance

Database sparse lookup vs. join
Improving performance in parallel jobs

        • Understanding a flow
        • Performance monitoring
        • Resolving bottlenecks
        • Ensuring data is evenly partitioned

Programming in data stage
Introduction to programming components
Routines

        • Transform functions
        • Before /after subroutines
        • Custom universe functions
        • Active (ole) functions
        • Subroutines
        • Creating a routine
        • Defining custom transforms

Transforms
Macros
Precedence rules
BASIC programming
Built in transforms and routines

        • Handling web services in data stageIntroduction to web services technologies

Encoding requests and responses
Using the soap framework
Publishing web service operations
Accessing web services
What is the web service pack
Using the web service meta data importer
Using the web services transformer stage
Using the web services client stage
Creating web service routines
How to expose data stage job as a web service
? Using IBM information console
Job scheduling using job sequences in data stage
Creating a job sequence

        • Overview of activity stages
        • Triggers
        • Expressions
        • Job activity properties
        • Routine activity properties
        • Email notification activity properties
        • Wait for file activity properties
        • exception activity properties
        • Nested condition activity properties
        • Start loop activity properties
        • End loop activity properties
        • User variables activity properties
        • Compiling and restarting the job sequence

Some advanced concepts in data stage

        • Achieving reusability in data stage using containers
          • Types of containers
          • Local containers
          • Server shared containers
          • Parallel shared containers
        • Creating a shared containers
        • Using shared containers in data stage jobs
        • Converting shared containers to local containers
        • Deconstruction of shared containers
        • Specifying our own parallel stage
          • Defining custom stage
          • Defining build stage
          • Build stage macros
          • Defining wrapper stage
        • Usage of administrator client in datastage
          • Adding environment variables
          • Setting job parameters default values
          • Changing license details
          • Handling projects
        • Buffer settings in data stage
        • Multiple instances of jobs in data stage
        • Data stage job control utility
        • Jobs – compilation execution and checking of logs using data stage tool
        • Handling multilingual data in data stage
        • How to enable NLS on data stage
        • Orchestrate architecture and commands
        • Orchestrate parallel processing framework in datastage
        • Orchestrate utility in data stage
        • Surrogate key generation using data stage
        • Version control in data stage

 

DB2 DATABASE ADMINISTRATION

Introduction

  • Brief History of Db2
  • Different product types in DB2
  • Various editions of Db2

DB2 Server Management

  • Detailed analysis of DB2 architecture
  • Demonstrate the ability to configure/manage DB2 servers, instances, and databases
  • Demonstrate the ability to obtain and modify registry variable information
  • Demonstrate the ability to obtain/modify database manager configuration information
  • Demonstrate the ability to obtain/modify database configuration information

Built-in tools

  • Demonstrate the ability to schedule jobs
  • tools catalog
  • Task Manager
  • Administration Configuration (DAS)
  • Demonstrate the ability to use autonomic features
  • Automatic Maintenance
  • Self-Tuning Memory Manager
  • Utility throttling

Physical Design

  • Analysis Instance ana databse
  • Various Background process in db2
  • Demonstrate the ability to create a database and manipulate various DB2 objects
  • Create database
  • Create and discuss the characteristics of DMS, SMS, and AS table spaces
  • Describe the use of schemas
  • Demonstrate knowledge of partitioning capabilities
  • Range/table partitioning

XML data objects

  • XML indexes
  • XML data types
  • XML functions
  • New features in V9.7

Database compression

  • enabling compression
  • index compression
  • automatic dictionary creation
  • replication support
  • compress XML and LOBs inline
  • temporary tables

Business Rules Implementation

  • Demonstrate the ability to create constraints on tables
  • Referential Integerity
  • Informational
  • Unique constraints/unique indexes/primary keys
  • NOT NULL
  • WITH DEFAULT
  • Check
  • Demonstrate the ability to create views WITH CHECK OPTION
  • LOCAL
  • CASCADE

Monitoring DB2 Activity

  • Demonstrate the ability to use Admin views and SQL functions for monitoring
  • ADMIN_GET_INDEX_COMPRESS_INFO
  • Demonstrate the ability to use Work Load Manager
  • time spent metrics
  • new waterfall approach to set up
  • Demonstrate the ability to use additional auto-monitoring tools
  • Event monitoring
  • Demonstrate the ability to configure Health Monitor using the Health Center
  • Demonstrate the ability to identify the functions of Problem Determination Tools
  • db2pd
  • db2mtrk
  • db2diag command
  • Interpret the Notify log
  • Describe the various table space states
  • db2top
  • Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
  • EXPLAIN FROM SECTION


Utilities

  • Demonstrate the ability to use the data movement utilities
  • Demonstrate the ability to use EXPORT utility to extract data from a table
  • Demonstrate the ability to use IMPORT utility to insert data into a table
  • Demonstrate the ability to use the LOAD utility to insert data into a table
  • Knowledge to identify when to use IMPORT vs. LOAD
  • DB2Move
  • DB2Look
  • Demonstrate the ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities
  • Demonstrate the ability to use the DB2 Advisor utility
  • db2advis utility
  • GUI
  • Describe the purpose of Data Studio Administrator (basic concepts � replacing existing DB2 tools)

Db2 backup and restore

  • Describe DB2 data integrity actions
  • transactions and logging
  • logging strategies
  • crash recovery
  • version recovery
  • roll forward recovery
  • Demonstrate the ability to perform database-level and table space level backup and recovery operations
  • BACKUP
  • RESTORE
  • ROLLFORWARD
  • RECOVER
  • Describe backing up with split mirroring

High Availability

  • Demonstrate the ability to configure and manage HADR
  • automatic client re-route

Security

  • Describe DB2 authentication
  • Describe DB2 authorizations and privileges
  • Describe the ability to set and remove user, group, and role authorities and privileges
  • Roles
  • GRANT
  • REVOKE
  • Demonstrate general knowledge of the Audit facility
  • Demonstrate knowledge of the DB2 Security Infrastructure
  • LBAC
  • Trusted contexts
  • LDAP
  • Plug-ins


Connectivity and Networking

  • Demonstrate the ability to configure database connectivity
  • steps required to setup connection pools
  • using DB2 DISCOVERY
  • Demonstrate knowledge federating communications
  • connection concentration
  • sysplex utilization
  • DB2COMM
  • automatic client re-route
  • Demonstrate knowledge of using JDBC/SQLJ connections with DB2
  • DB2 drivers
  • licensing

 

 
Erwin Data Modeler
Introduction to Erwin
Starting Erwin
Creating Entities
Creating Relationships
Creating Subtypes
Creating Schemas
Defining Domains
Defining a Domain Constraint
Applying Domains
ERD to Database Schama
Creating databases
Creating an Oracle database
Creating an Access Database

 

Hyperion Essbase 9.3

 Online Analytical Processing Overview

  • Data Transformation
  • Multidimensional View of Information
  • Multidimensional Data Model
  • OLAP Solutions

Analytic Services Overview

  • Business Performance Management
  • Hyperion System 9 Overview
  • Hyperion Analytic Solution
  • Analytic Services
  • Analytic Administration Services

 Creating Multidimensional Databases

  • Life Cycle of the Essbase Analytics Database Design
  • Creating Essbase Analytics Applications and Databases
  • Creating and Managing Database Outlines
  • Creating Time, Accounts, and Scenario Dimensions

 Calculating the Essbase Analytics Database

  • Outline Calculations
  • Calculation Scripts
  • Two-Pass Calculations
  • Dynamic Calculations
  • Dynamic Time Series

 Retrieving Data

  • Smart View Overview
  • Connecting to the Analytic Server
  • Retrieving Multidimensional Data into Two-dimensional Spreadsheet Reports
  • Navigating Through Spreadsheet Reports
  • Manipulating Multidimensional Data
  • Installing the Web Server
  • Smart View Options

 Enhancing Database Outlines

  • Creating Business-view Dimensions
  • Specifying Consolidation Operators and Defining Calculations
  • Setting Time Balance Properties
  • Creating Label-Only and Shared Members
  • Defining Duplicate Member Names and Member Aliases
  • Creating Attribute Dimensions

 Loading Data

  • Data Load Options
  • Loading Data from Flat Files
  • Performing Free-Form Data Loads
  • Loading Data with Rules Files
  • Loading Data from SQL Data Sources

 Advanced Spreadsheet Reporting

  • Updating Data on the Analytic Server
  • Creating Free-Form Reports
  • Selecting Members
  • Creating Reusable Queries
  • Extending the Spreadsheet Environment with Visual Explorer

  Storing Analytic Data

  • Data Storage Options
  • Block Storage
  • Block Storage
  • Aggregate Storage

Integration with BI+ Reporting Tools

  • BI+ Architecture
  • Workspace Overview and User Interface
  • Browsing the Repository
  • Working with BI+ Content
  • Previewing Financial Reports
  • Grouping Financial Reports into Books

 Extending Analytic Reporting Using Web Analysis

  • Web Analysis Overview
  • Viewing Web Analysis Documents in Workspace
  • Analyzing Query Results in Workspace
  • Creating Web Analysis Documents
HYPERION INTERACTIVE REPORT

 

Starting Interactive Reporting.

  • Starting Interactive Reporting.

Opening and Saving a Sample File.

  • Opening and Saving a Sample File.

Creating a sample query

  • Creating a sample query

Viewing Database Tables.

  • Viewing Database Tables.

Adding Topics to query

  • Adding Topics to query

Viewing Results.

  • Reordering Columns.
  • Sorting Columns
  • Filtering Data.
  • Calculating Data.
  • Pivoting Data.
  • Drilling Down.
  • Hiding Data.
  • Adding Color.

Charting data.

  • Sorting Charts.
  • Inserting Text Labels.

Designing Reports.

  • Creating smart Reports.
  • Sorting Columns.
  • Setting up a Report page.

Inserting Sections and Breaks.

  • Inserting Sections and Breaks.

Changing Views.

  • Changing Views.

Formatting Text and other elements.

  • Formatting Text and other elements.

Setting interactive reporting options.

  • Setting interactive reporting options.

Exporting document as web page.

  • Exporting document as web page.

Export to HTML Wizard.

  • Export to HTML Wizard.

Spot lighter.

  • Spot lighter.

Querying

  • Query Section.
  • Building queries.
  • Processing Queries
  • Saving Queries
  • Derived Tables.
  • Working with query section data.

Results

  • Results section.
  • Enhancing your results set.
  • Working with results table.
  • Saving Results set.
  • Exporting Results set

Working with Tables.

  • Table Section.
  • Creating Tables.
  • Manipulating Table Data.
  • Working with Table Components.

Querying Multidimensional Databases

  • Olap Query Section
  • Defining OLAP Query Options
  • Building OLAP Queries.
  • Refining OLAP Query data.
  • Processing OLAP Queries.
  • Applying Filters.

Cube query:

  • Cube Query Catalog.
  • Member selection.
  • Query options.
  • Showing as Chart.
  • Exporting a Cube query.

Analyzing Data with Pivot Tables.

  • Creating Pivot Table.
  • Charting a Pivot table.
  • Working with Pivot table.
  • Pivoting Data.

Report Designer.

  • Report Section.
  • Creating a custom report.
  • Working with a report page.
  • Formatting report items.

Computed Items.

  • About Computed Items.
  • Adding Computed items.
  • Common computed item example.

Applying Sorts.

  • Sorting Data.
  • Simple Sort.
  • Sort lines.
  • Complex Sorting.
  • Nested Sorting.

Understanding Connectivity in Interactive Reporting.

  • About IR Database connection files.
  • Working with interactive reporting connection.
  • Connecting to database.

Data Modeling.

  • About Modeling.
  • Building a data model.
  • Understanding joins.
  • Working with Data Models.

Security for Interactive reporting.

  • Security for Interactive reporting.

Introduction to dashboards.

  • Introduction to dashboards.

Migrating reports with dashboards

  • Migrating reports with dashboards

 

IBM Cognos 8

Topics:

Cognos Interface
• Navigating the portal
• Content and functionality
• Creating folders
• Scheduling reports and jobs

Report Studio Overview
• Report Studio capabilities and basics
• Report types and templates
• Running reports

Report Studio Navigation
• Defining the toolbars
• Viewing a report
• Explorer bars
• Report structure
• Adding report objects
• Displaying data
• Creating queries

Organizing and Summarizing
• Using lists and crosstabs
• Sorting
• Grouping
• Report sections
• Summarizing, Aggregation

Filters and Prompts
• Report functions
• Stand alone, embedded
• Detail and summary filters
• Prompt objects
• Prompt pages

Calculations and Conditional Formatting
• Query calculations
• Layout calculations
• Creating and applying variables

Layout Formatting
• Styling
• Free standing objects
• Tables
• Alignment, spacing, object size
• Headers and Footers
• Page Sets

Extra!
• Advanced formatting
• Working with Queries
• Visualizations (Charts and Maps)
• Beyond the Report
• Encountering Problems and Issues

 

 
Informatica

Introduction and Architecture

  • Introduction to Informatica
  • Architecture of Informatica — Power Center 8.1
  • Informatica Design Process
  • Informatica Client Tool — Designer
  • Source Analyzer and Warehouse Designer

Mapping Designer

  • Create a Simple Mapping
  • Overview of Transformations
  • Types of Transformations — Active and Passive
  • Expression Transformation
  • Source Qualifier Transformation
  • Introduction to Workflow Manager
  • Control Flow Statements
  • Task Developer
  • Workflow Designer
  • Creating Connections

Flat Files Handling

  • Create Simple Mappings
  • Flat File Analysis

Architecture Review

  • Architecture 8.1 Review
  • Differences between Power Mart and Power Center
  • Connecting to SAP
  • FTP Process
  • Command Task
  • Create a Mapping
  • Joiner Transformation

Transformations

  • Create a Mapping
  • Using Join in a Source Qualifier Transformation
  • Expression Transformation
  • Filter Transformation

Transformations Contd

  • Multiple Targets Loading
  • Router Transformation
  • Diff between Filter and Router Transformations
  • Create a Mapping
  • Master Outer Join

Transformations Contd

  • Create a Mapping
  • Reusable Transformation
  • Lookup Transformation
  • Debugger
  • Handling Multiple Files as Source

Mapplets

  • Create Mappings
  • Sequence Generator Transformation
  • Multiple Pipelines in a Single Mapping
  • Target Load Plan
  • Mapplets

Update Strategy

  • SCD Type 1 mapping Implementation
  • Update Strategy Transformation

SCD Type 2

  • SCD Type 2 mapping Implementation

Loading Strategy

  • Sequential and Parallel Loading
  • Union Transformation
  • Dynamic Lookup Cache
  • Introduction to Fact Loading
  • Create a Mapping

Transformations Contd

  • Create a Mapping
  • Date Dimension Loading
  • Lookup Transformation – Persistent Cache
  • Aggregator Transformation
  • Sorter Transformation
  • Creating Stored Procedure

Transformations Contd

  • Normalizer Transformation
  • Stored Procedure Transformation
  • Active Vs Passive Transformations
  • Connected Vs Unconnected Transformations

Implementing Incremental Loading

  • Create a Mapping
  • Importance of Mapping Variable

Implementing Incremental Aggregation

  • Create a Mapping
  • Incremental Aggregation

Transaction and Variable Port

  • Transaction Control Transformation
  • Variable Ports

Workflow Tasks

  • Scheduling
  • Task Link Properties
  • Event Raise Task
  • Event Wait Task
  • Work let

Others

  • Parameter Files
  • Removing Duplicate Rows
    Informatica PowerCenter 8.6/9.0 Administrator

    • Primary Elements
      Discuss the essentials of the PowerCenter 8.5+ Architecture
    • Best Practices
      Learn how to configure a PowerCenter 8.5+ environment using recognized Best Practices
    • Install PowerCenter 8.5+
      Prepare for and Install PowerCenter 8.5+.
    • Configure Services
      Configure PowerCenter 8.5+ application services
    • Understand and configure PC Unified Security.
    • Services Management
      Describe the architecture of the PowerCenter Services
    • Deployments
      Discuss different methods of Powercenter Deployments
    • Command-Line Programs
      Use PowerCenter command line programs to administer the domain
    • Subject Area Implementation
      Implement a Subject Area into the PowerCenter architecture.
    • Metadata Reporting
      Use Metadata Exchange (MX) views to report PowerCenter operational information.
      Create and configure a PowerCenter Reporting Service.
      Understand the purpose of the Data Analyzer tool.
    • Reference Table Manager Service
      Learn how to configure and use RTM Service
    • Domain Management
      Learn how to manage the PowerCenter Domain

     

    Informatica ETL

    INTRODUCTION
    Transaction Database
    Transaction Database Definition and features
    E-R Data Model
    Database Normalization using Six Normal Forms
    Database Denormalization

    Warehouse Database
    Data Warehouse Definition and Features
    Difference between Transaction Database and Warehouse Database
    Dimensional Data Model
    Star Schema Model
    Star Flake Schema Model
    Snow Flake Schema Model
    Extended Star Schema Model
    Galaxy Schema Model
    Cube Designing using different models
    Denormalization of  Data Warehouse
    Other Databases
    Data Mart
    Staging Database
    Operation Data Storage/Source (ODS)

    Database Modeling using ERWIN
    Logical Data Model and Physical Data Model
    Models, Subject Areas and Display Objects
    Entities, Relations, Attributes and Business Rules
    Relation Cardinalities, Verb Phrases, Relation Types & Referential Integrity
    ERWin Macros, Model Properties, Model Mart

    ETL PROCESS

    INFORMATICA
    Introduction to ETL Process
    Informatica Packages
    Components of Informatica Tool
    Informatica Repository Server/Service:
    Setting up Informatica Service using Repository Server Setup Tool
    Starting Informatica Service
    Repository Server Administration Console:
    Creation of  new Repositories
    Maintainance of Repositories
    Repository Manager Tool
    o        Creation of Folders, Users, Groups within Repositories
    o        Granting Privileges
    Designer Tool:
    Components of Designer Tool
    Pre-defined of  Transformations, Ports, Types of Ports
    Source Definition, Target Definition and Mappings
    Examples of Pre-defined Transformations
    User-defined Transformations
    Mapplets
    Workflow Manager Tool:
    o        Creation of Server(s), Database Connections
    o        Creation of Workflow and Tasks
    o        Sequential or Concurrent Relation
    o        Session and other Tasks Properties
    o        Setting up of Informatica Service using Informatica Server Setup Tool
    o        Starting Informatica Service/Server
    o        Scheduling/Execution of Workflow
    o        Monitoring Data Loading Process
    o        Tracing Errors
    Cube Example from Retail Business Analysis Domain
    Using Debugger within Designer Tool
       

     

       

      Informatica PowerCenter 8.6/9.0 Level I Developer

      • Data Integration Concepts
      • PowerCenter Components and User Interface
      • Source Qualifier
      • Expression, Filter, File Lists and Workflow Scheduler
      • Joins, Features and Techniques I
      • Lookups and Reusable Transformations
      • Debugger
      • Sequence Generator
      • Lookup Caching, More Features and Techniques
      • Sorter, Aggregator and Self-Join
      • Router, Update Strategy and Overrides
      • Dynamic Lookup and Error Logging
      • Unconnected Lookup, Parameters and Variables
      • Mapplets
      • Mapping Design
      • Workflow Variables and Tasks
      • More Tasks and Reusability
      • Worklets and More Tasks
      • Workflow Design

       

       
      Microstrategy
      Introduction

      • Business Intelligence
      • OLAP
      • Introduction Of BI tools
      • Database Overview

      Introduction of Microstrategy

      • Microstrategy Architecture
      • Microstrategy Desktop
      • Microstrategy Web
      • Microstrategy Servers
      • Administration
      • Folder Structure
      • My Personal Objects
      • Public Object
      • Schema Object
      • Metadata
      • Report View
      • Data – Export
      • AutoStyles
      • Custom Groups
      • Facts
      • Tables
      • Update Schema
      • MicroStrategy Tutorial (Direct)

      Advance features

      • Project Configuration
      • Attribute Creation
      • Metric Creation
      • Drill Map
      • Templates
      • Prompt
      • Filter
      • Administration Facts
      • Creation Of Reports
      • Grid Report
      • Analyzing Data
      • Transformations
      • Hierarchies
      • Data Explorer
      • Adhoc Report
      • Report Creation on Web
      • Searches
      • Documents
      • Joins

      Experts Features and Administration

      • Project
      • Installation
      • Intelligence Server
      • User Creation
      • User Privilege
      • Security Implementation
      • Object manger
      • Command Manager
      • Formatting Report
      • Understanding Requirement
      • Performance Improvement
      • SQL Creation
      • Challenges in Report
      • Administrative Configurations

       

      MSBI

      Microsoft – BI
      (SSIS, SSAS, SSRS)

      SSIS–Objectives:

      1. Plan data transfer and staging solutions for an ETL operation.
      2. Plan an SSIS Solution
      3. Design and implement data flows
      4. Incorporate logging, error handling, and reliability into a package.
      5. Optimize an SSIS solution
      6. Deploy and operate an SSIS solution.


      SSAS – Objectives:
      1. Describe how SQL Server Analysis Service can be used to implement Analytical Solutions.
      2. Create multidimensional analysis solutions with SQL Server Analysis Services.
      3. Implement dimensions in an Analysis Services Solution.
      4. Implement measure and measure group in an Analysis Services Solution.
      5. Query a multidimensional Analysis Service Solution.
      6. Customize an Analysis Service cube.
      7. Deploy and Secure an Analysis Service database.
      8. Maintain a multidimensional Analysis Service Solution.
      9. Implement a Data Mining Solution.

      SSRS – Objectives:

      1. Describe SQL Server Reporting Services and its Components.
      2. Create a Reporting Services report.
      3. Enhance a Reporting Service report.
      4. Create and manipulate data sets.
      5. Use report models to implement reporting for business users.
      6. Configure report publishing and execution settings.
      7. Implementing subscription for reports.
      8. Implement custom Reporting Services applications.

      SAS
      PART-I
      BASE SAS
      Introduction To SAS System & Architecture
      History And Various Modules
      Features
      Variables & SAS Syntax Rules
      SAS Data Sets
      Data Set Options
      Operators
      Reading Raw Data
      Infile Statement With Options
      Working With External Files & Options
      Multiple Observations
      Input Styles
      Select Statement
      Leave and Continue Statements
      Creating & Redefining Variables
      Where Statement
      If – Then Else Statement
      Goto, Stop And Error Statements
      Output Statement, Put Statement
      Do Loops
      Modifying And Combining Data Sets
      Updating Master Data Set
      Display Manager Commands
      SAS Functions
      BASE SAS PROCEDURES
      Proc sort
      Proc Print
      Proc Means
      Proc Freq
      Proc Plot
      Proc Chart
      Proc Copy
      Proc Summary
      Proc Append
      Proc Datasets
      Proc Contents
      Proc Delete
      Proc Format
      Proc Import
      Proc Export
      PART -II
      ORACLE-SQL CONCEPTS
      Introduction
      History
      Features
      Sql Command Set
      Operators In Sql
      Order By Clause
      Group By Clause
      Having Clause
      Distinct Clause
      Create and Insert
      Deleting, Populating And Updating
      SAS/SQL
      Introduction  To SAS/Sql
      Features
      Uses
      Terminology
      Data Types, Key Words, & Operators
      Functions, Predicates
      Formatting Output
      Group By Clause
      Order By Clause
      Having Clause
      Case Expression And Conditional Logic.
      Creating ,Populating & Deleting Tables
      Alter Table Statement
      Changing Column’s Length
      Joins
      Constraints
      Renaming A Table & Columns
      Views
      SAS/ACCESS
      Working With Oracle
      Working With Ms-Access
      Working With Ms-Excel
      DBLoad Procedure
      SAS/GRAPH
      Gchart Procedure
      Vertical, Horizontal, Pie
      Donut
      G3d
      Group, Subgroups
      Gplot  Procedure
      Multiple Plots & Overlay
      Symbol Statement
      Title  And Footnote Statements
      Goptions
      SAS/REPORTS
      Frequency Report
      One-Way Frequency Report
      Cross Tabular Frequency Report
      Summary Statistics
      Creating A List Report
      Define Statement
      Order Usage and Group
      Printing Grand Totals
      Rbreak Statement
      Tabulate Procedure
      One-Dimensional Tables
      Two-Dimensional Tables
      Obtaining A Total
      Analysis Variables with options
      Summary Statistics
      SAS/MACROS
       Macro Concepts
      Macros And Macro Variables
      Creating Macro Variables
      Using Macro Variables
      Creating Modular Code With Macros
      Invoking A Macro
      Adding Parameters To Macros
      Macros With Conditional Logic
      Using Various Procedures In Macros
      Automatic Variables
      Macro Functions
      Including External Macros
      SAS/STAT
      Proc Univariate
      Proc Corr
      Proc Reg
      Proc Anova
      SAS/ODS
      Creating Rtf File
      Creating Html File
      Creating Pdf File

       

      TERADATA
      Teradata
      Teradata Architecture and Components

      • PDE(Parallel Data Extension)
      • Vprocs (virtual processors)
      • PE (Parsing Engine)
      • AMP (Access Module processing)
      • Board less Bynet
      • TDP (Teradata Directory Program)
      • CLI (Call Level Interface)
      • TPA (Trusted parallel Application)

      Going in depth by explaining the process of SQL statement execution
      Various Architecture

      • Node Architecture (shared nothing)
      • SMP Architecture
      • MPP Architecture
      • Parallelism Architecture
      • Benefit & types

      Data Recovery and Protection

      • Object Locks-Various locks for simultaneous access
      • RAIDI
      • RAIDI5
      • Disk Arrays
      • Fall Back
      • Clique
      • AMP Clustering
      • Journals

      Teradata Storage and Retrieval Architecture
       Request processing
      a.       Syntaxer
      b.      Resolver
      c.       Security Module
      d.      Optimizer
      e.       Step Generator
      f.       GNC Apply
      g.       Dispatcher
         Primary index
      1.      Hash algorithm
      2.      Row hash
      3.      DSW
      4.      Hash Map
      5.      Hash Bucket
      6.      Reaching Vdisk
      Teradata Indexes
      �   Primary Index
      �         Unique
      �         Non unique
      �         Partitioned
      �  Secondary Index
      �         Unique
      �         Non unique
      �         Hash, Join, Value Ordered
      �         Skewness
      �         Secondary Index Sub table
      �         Accessing Records via primary index
      �         Accessing records via Secondary index
      �         Keys vs indexes
                

      Teradata Sql Reference
      �         Fundamentals
      �         Data Types and Literals
      �         Data Definition Statements
      �         Data manipulation statements

       

      Teradata Functions and Operators
      �         String functions
      �         Format functions
      �         Cast functions
      �         Group & Aggregate functions
      �         With & with by clauses
      Teradata Transactions
      �         Implicit Transaction
      �         Explicit Transaction
      Performance Tuning and Explain Utility
      �         Explain Usage
      �         Collection Statistics
      �         Tuning SQL Performance
      �         Usage of PMON
      Joints & Unions
      �         Inner Join
      �         Left Outer Join
      �         Right Outer join
      �         Full Outer Join
      Join strategies
      �         Product join
      �         Merge Join
      �         Hash Join
      �         Nested join
      Teradata Basic Commands
      �         HELP
      �         SHOW
      �         EXPLAIN
      �         COLLECT STATISTICS
      Teradata objects
      �         Tables
      1.      SET table
      2.      Multi Set table
      3.      Volatile tables
      4.      Global Temporary tables
      5.      Derived tables
      �         Views
      �         Macros
      �         Stored procedures
      �         Triggers
      Teradata spaces
      �         PERM space
      �         SPOOL space
      �         TEMPORARY space
      �         Teradata user and managing.
      Teradata Transaction Modes
      �         BTET
      �         ANSI
      �         Interactive
      �         Batch
      Load and Unload Utilities & Tools
      �         Teradata Sql Assistant (Queryman)
      �         Teradata Performance Monitor
      �         Teradata BTEQ
      a.       Batch Scripts with samples
      b.      Branching and Looping
      c.       Importing data through scripts
      d.      Exporting data through scripts
      e.       Session Control Command Set
      f.       Error handling.
      �         Teradata Fast load
      a.       Various Phases of Fast Load
      b.      Advantages and Process
      c.       Limitations of Fast Load
      d.      Sample scripts
      �         Teradata Multi Load
      a.       Various Phases of Multi load
      b.      Limitations of Multi Load
      c.       Working with multiple tables
      d.      Applying various operations
      e.       Sample Scripts