Our prime partner network:
 
     

- - WHY TRAINING?

- - WHO ARE PILGRIMS!
- - PILGRIMS PARTNER PROGRAM

- - CAREER COUNCELLING

- - STUDENT SERVICES
- - SUCCESS STORIES
- - REFERRAL PROGRAM

- - INFO. REQUEST

 

CONTACTS:

Ranganath Katari

734-328-6063 (O)

734-968-9182 (C)

rkatari@velosyscorp.com

 

ADDRESS:

35240 Nankin Blvd, Suite 403

Westland MI 48185

(Behind Westland Mall)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Course Name: Informatica/BO

Course Number: etl-t-7XXX

Pre-Requisites

  • Bachelors or Masters
  • Basic understanding of SQL

Topics Coverd

 

Program 1 - Data Warehouse Concepts

Introduction

  • Need of Data Warehouse
  • Importance of Transaction Systems – OLTP
  • Characteristics of OLTP
  • Purpose of Analysis
  • Definition of Data Warehouse
  • Goals of Data Warehouse

Architecture of Data Warehouse

  • Architecture of Data Warehouse
  • Characteristics of Data Warehouse
  • Dimension Modeling
    • Dimension and Fact Tables
    • Size of Fact Table
    • Difference between OLTP and Data Warehouse
    • Surrogate Keys
    • Grain Level
    • Types of Facts – Additive, Semi Additive, Non Additive
    • Star Schema
    • Snow Flake Schema

Implementation Methodology

  • Data Mart
  • Difference between Data Mart and Data Warehouse
  • Inmon Methodology
  • Kimball Methodology
  • Load Window
  • Development / Test / Production Environment
  • Initial Load
  • Incremental Loading
  • Importance of Staging

Slowly Changing Dimensions (SCD)

  • SCD Type 1
  • SCD Type 2
  • SCD Type 3
  • Time Dimension
  • Conformed Dimension
  • Meta Data Management

Program 2 - Informatica 7.1

Informatica Architecture

  • Introduction to Informatica
  • Architecture of Informatica – PowerCenter 5.1
  • Architecture of Informatica – PowerCenter 7.1
  • Informatica Client Tool – Designer
    • Source Analyzer - Create Source Definition
    • Warehouse Designer – Create Target Definition

Mapping Designer

  • Create a Simple Mapping
  • Overview of Transformations
  • Types of Transformations – Active and Passive
  • Expression Transformation
  • Source Qualifier Transformation

Workflow Manager, Transformations

  • Introduction to Workflow Manager
  • Task Developer
  • Workflow Designer

Transformations

  • Aggregator Transformation
  • Importance of Cache
  • Sorter Transformation
  • Joiner Transformation
  • Filter Transformation
  • Router Transformation
  • Union Transformation

Transformations

  • Sequence Generator Transformation
  • Stored Procedure Transformation
  • Normalizer Transformation
  • Lookup Transformation
  • Update Strategy Transformation

Incremental Loading, Slowly Changing Dimension

  • Mapping Variable
  • Source to Staging Loading – SCD Type 1
  • Source to Staging Loading – SCD Type 2
  • Staging to Dimension Loading – SCD Type 1

SCD Type 2 Loading, Workflow Manager

  • Staging to Dimension Loading – SCD Type 2
  • Lookup Cache – Static, Persistence, Dynamic
  • Reusable Transformation
  • Mapplet Designer

Workflow Manager

  • Email Task
  • Command Task
  • Scheduling of Workflow
  • Event Raise
  • Event Wait
  • Worklet Designer

Program 3 - Business Objects XI R 2

Architecture of Business Objects

  • Architecture – BO XI R2

Universe

  • Introduction to Desinger Tool
  • Define Universe
  • Connections – Universe
  • Classes and Objects
  • Types of Joins
  • Equi Join, Theta Join, Self Restricted Join
  • Shortcut Join, Left/ Right Outer Join
  • Full Outer Join

Loops, Traps

  • Loops – Define
  • Resolving Loop by Alias
  • Chasm Trap – Define
  • Resolving Chasm Trap by Context
  • Resolving Loop by Context

Traps, Linking/ Including Universe

  • Fan Trap – Define
  • Resolving Fan Trap
  • Linking Universe
  • Including Universe
  • Conditions – Filters, Prompts
  • Hierarchy

Reporting

  • Introduction to Desktop Intelligence Tool
  • Formatting Report – Sizing, Calculations
  • Charts
  • Drill Through – Drill Up / Drill Down
  • Slice and Dice
  • Filters
  • Prompts

Reporting

  • Multiple Data Providers
  • Different Sources – Flat File, Free Hand SQL
  • Variables /Formulas
  • Alerts
  • Cascading Prompts
    • Reporting – Web
  • Introduction to Info View and Web Intelligence
  • Formatting Report – Sizing, Calculations
  • Charts
  • Drill Through – Drill Up / Drill Down
  • Filters
  • Prompts
  • Multiple Data Providers
  • Variables / Formulas
  • Alerts
  • Sharing Documents

Advance Topics – Universe

  • User Defined Outer Joins
  • Aggregate Awareness

Environment

Server: Windows 2003 Server, Oracle9i, Business Object XI Enterprise, Informatica Server

Client: Window XP, Oracle Client, Informatica Client and Business Objects Client, Toad

 

 

 

 

 

Call us or click Registration to reserve your spot.

* Pilgrims also offer fast track PRE-REQUISITES training in Java, XML *

Course Duration: 66hrs (5.5 week ends)

Classes are held at:

Local Training

35240 Nankin Blvd., Suite 403, Westland MI 48185

Global Training

Over the Internet with live tutors, Lab Assistants and Administrators at the comforts of your home.

-------------------------------------------

Why Pilgrims?

Pilgrims follows global best practices when it comes to Training Methodologies, Security Processes and Practices within the organization. Our highly secure, robust and agile infrastructure has been rated 'best in class' during client audits.

Pilgrims trains it's prime partner employees and prospective employees on ERP, CRM and other cutting edge technologies like Documentum as part of the continuous learning initiative at the Velosys’s state of the art training facility.

  • State of the art lab & class room facilities
  • Unlimited lab access
  • Limited class size
  • Interview preparation
  • Placement Assistance
  • Developed by Pilgrims certified instructors with over 30 collective years of technical experience
  • Excellent course material with tutorials
  • Sun Certified Instructors with years of EMC Training Experience
  • Instructors with over ten years of industry experience
  • Instructors with master's degrees and prior training experience
  • Support when you are on project
  • H1B and Green card processing for the international students of all visa categories

The fundamental objective of the course is to prepare students for the contract and fulltime Documentum positions at various fortune 500 companies apart from all the small and mid range corporates requiring Documentum talent.

-------------------------------------------

Why ETL and related Software Products?

Extract, Transform, and Load (ETL) is a process in data warehousing that involves

  • extracting data from outside sources,
  • transforming it to fit business needs (which can include quality levels), and ultimately
  • loading it into the end target, i.e. the data warehouse.

ETL is important, as it is the way data actually gets loaded into the warehouse. This article assumes that data is always loaded into a data warehouse, whereas the term ETL can in fact refer to a process that loads any database. ETL can also be used for the integration with legacy systems. Usually ETL implementations store an audit trail on positive and negative process runs. In almost all designs, this audit trail is not at the level of granularity which would allow to reproduce the ETL's result if the raw data were not available.

-------------------------------------------

We also offer FREE training to the qualifying individuals.

* Please contact the administrative staff for the terms and conditions.

* Still confused? If you need counseling please schedule an appointment and walk in to talk to our experts or just walk in on a career night.

* We also have a FREE overview/Demo class. Please sign up as soon as possible as there is a 12 member restriction per class room.