OBIEE 11g online training institute from hyderabad

Sponsored Ads

Price: Check with seller

Data warehouse ConceptsData WarehouseBasics of Data WarehousingWhat is OLTP and OLAP?Difference between OLTP and OLAPDim...

  • Category: Computer - IT - Webs
  • Published: 27/02/2015
  • Current Rating: /5 0 Vote

    Description


    • Data warehouse Concepts

      • Data Warehouse

      • Basics of Data Warehousing

      • What is OLTP and OLAP?

      • Difference between OLTP and OLAP

      • Dimensional table

      • Fact table

      • Aggregate table

      • Star schema

      • Snowflake schema

      • Star schema Vs. Snowflake schema

      • Fact Vs. Dimension table

      • Fact Vs. Aggregate Table



    • Overview of OBIEE

      • Introduction to Siebel Analytics

      • What is OBIEE?

      • Introduction to OBIEE 10G

      • Introduction to OBIEE 11G

      • Advantages of OBIEE

      • End to End Life Cycle of OBIEE

      • Oracle BI Architecture 11g vs. 10g

      • Oracle BI Components 11g vs. 10g



    • Installation of OBIEE

    • Repository & Catalog Basics

      • Repository Basics

      • What is Metadata & Catalog?

      • Creating a Repository using BI Administration Tool

      • Physical, Business Model and Mapping and presentation layers

      • Properties of repository objects

      • Online Mode and Offline Mode

      • Answers, Dashboards, Administration

      • Loading a Repository & Catalog into Oracle BI Server memory

      • Administration files, Logs, Services, Folders



    • Building the Physical Layer of a Repository

      • Importing data sources

      • Setting up connection pool properties

      • Defining keys and joins

      • Examining physical layer object properties

      • Creating alias and select tables



    • Building the Business Model and Mapping Layer of a Repository

      • Building the Business Model and Mapping Layer of a Repository

      • Building a business model

      • Building logical tables, columns, and sources

      • Defining logical joins

      • Building measures

      • Examining business model object properties



    • Building the Presentation Layer of a Repository

      • Exploring Presentation layer objects

      • Creating Presentation layer objects

      • Modifying Presentation layer objects

      • Examining Presentation layer object properties



    • Testing and Validating a Repository

      • Checking repository consistency

      • Turning on logging

      • Defining a repository in the initialization file

      • Testing a repository using Oracle BI Answers

      • Inspecting the query log



    • Adding Multiple Logical Table Sources & Adding Calculations to a Fact Table

      • Adding multiple logical table sources to a logical table

      • Specifying logical content

      • Creating new calculation measures based on existing logical columns

      • Creating new calculation measures based on physical columns

      • Creating new calculation measures using the Calculation Wizard



    • Creating Dimension Hierarchies and Level-Based Measures

      • Creating dimension hierarchies

      • Creating level-based measures

      • Creating share measures

      • Creating rank measures



    • Using Aggregates

      • Purpose of aggregate tables in dimensional modeling

      • Modeling aggregate tables to improve query performance

      • Testing aggregate navigation

      • Using the Aggregate Persistence Wizard



    • Using Variables

      • Session variables

      • Repository variables

      • Initialization blocks

      • Using the Variable Manager

      • Using dynamic repository variables as filters



    • Security

      • Creating users and groups

      • Setting permissions for users and groups

      • Authenticating using a external database

      • Authenticating using database authentication

      • Setting query limits and timing restrictions

      • Setting filters to personalize information



    • Cache Management

      • Restricting tables as non-cacheable

      • Using Cache Manager

      • Inspecting cache reports

      • Purging cache entries




    Phone Number : 9989275111

    Related Ads

    Leave your comment


    Copyright © 2016 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us: query[at]tuffclassified.com