All Topics

1. OBIEE BasicsOracle BI Architecture Components - Clients - Data Sources - Physical Layer Objects - Database Object General Properties - Connection Pool - Physical Table Properties - Alias - Select - View - Presentation Layer Objects - Nested Tables - Aliases - Presentation Catalog - Rename, Reorder, Delete, Rename, Reorder Columns - Consistency Check Manager - Logging Levels - NQQuery Log
2. BMM LayerBMM Layer Objects - Logical Complex Join - Measures – Formula - Aggregation Rule - Calculation Wizard - Physical Calculation - Logical Calculation - Dimension Hierarchies - Level-Based Measures - Share Measures - Parent-Level Object - Child-Level Object - Number of Elements - Level Columns - Level Keys - Preferred Drill Path - Time Dimension - Chronological Keys - Time Series Functions - Ago Measure - To Date Measure - Siebel Analytics Time Series Wizard- WHERE Filter
3. Multiple SourcesMultiple Sources - Logical Table Source (LTS) - Keys and Joins - Content -Aggregate Tables - Oracle BI Aggregate Navigation - Aggregated Facts - Modeling Aggregates - Aggregation Content - Logical Table Source and Mappings - Modeling Multiple Granularity Fact Tables- Partition - Partitioning by Fact - Value - Level - Complex Partitioning - Fragmentation - UNION ALL using Fragmentation
4. Initialisation BlocksVariables - Variable Manager - Variable Types - Repository Variables - Static Repository Variables - Dynamic Repository Variables - Session Variables - System Session Variables -Non-System Session Variables - Initialization Blocks – Row wise Initialisation -Relational database- Excel
5. Multi Star SchemasDimension Only Queries - Implicit Fact Column - OBIEE Behavior - Conformation dimensions - Multi Star Schema - Slowly Changing Dimensions - Extension Tables - Bridge Table - Helper Tables – Dimensional modeling in OLAP
6. SecurityOracle BI Security - Security Manager - Users - Groups - Administrators Group - Group Inheritance - Authentication - External Table Authentication - Database Authentication - Internal Authentication - Order of Authentication - Bypassing Security - Query Limits - Timing Restrictions - Filters - Answers/Dashboards - Managing Presentation Catalog Groups and Users - System Defined Presentation Catalog Groups - Web Permissions
7. CacheCache - Advantages - Costs - Cache Architecture - Cache Management Techniques - Cache Parameters - Cache Persistence for Tables - Cache Manager -Purging Cache –Seeding Cache Manually - Automatically - Event Polling Tables - Cache Hit Conditions - Bypassing Cache
8. RPD MergeOracle BI MUDE - Oracle BI Repository Three-Way Merge - Projects - Administration Tool Tasks during Checkout/Check In - Merge Decisions - Project History - Merge Process - Three-Way Merge - Two Way Merge – Import from Repository.
9. Admin Tool UtilitiesWizards and Utilities - Managing Joins - Managing Sessions -Querying Repository Metadata - Externalizing Strings – Rename Wizard- Repository Documentation- Metadata Dictionary - Event Table -Updating the Physical Layer
10. Advanced OBIEEClustering of OBIEE Servers - Write back - Oracle BI Multilingual Support - OBIEE Upgrade - Import Option - Repository - Merge - Repository Upgrade - webcat Upgrade - Usage of Saw Migrate Tool in OBIEE - Testing Strategy - OBIEE New Features - Differences between Siebel analytics and OBIEE - Usage Tracking - SA System Subject Area - Configuration - Usage
11. OBIEE AnswersArchitecture - Answers - Dashboards - Variables - Requests - Style - Modify request criteria format (Column, data, conditional) - Formulas - date functions - string functions - aggregate functions - Level based measures in reports - Nested aggregation - Advanced Formatting - Customized Date and Time Format - Filters - Parenthetical Filtering - Dynamic Filtering - Saved Request as a Filter - Editing SQL - Column Filter Prompt

12. Advanced FeaturesAdvanced Features - GROUP BY clause - Complex from clause - Joins between reports - Set Operations - Combining Results of Multiple Requests - Direct Database Request - Editing Logical SQL - Write back Report - Action Links - HTML - Java Scripts in Answers - Cascading Style Sheets - Modifying - Sample Style Sheet Entry - XML Message Files - XML Message Structure - Instanceconfig File - Web Administration Properties
13. Report ViewsCompound Layout View - Chart Options - Report Totals - Bins - Table - Title View - Filters View - Legend View - Narrative View - Ticker View - Logical SQL View - View Selector View - Column Selector View - Gauge Views - Pivot Table Views - Page – Sections – Measure Labels – Pivot table components Positioning- Aggregation Rules - Totals - Building Calculations
14. DashboardsInteractive Dashboards - Creation - Pages - Styles - Page Controls - Columns - Sections - Print Controls - Prompts - Scope - Control and Constraints - Set defaults - Set variables - Saved Selections - Links and Images - Embedded Content - Text - Text ActiveX -Text Scripts - Text Audio - Folders - BI Publisher Reports – Section Properties - Dashboard Links - Bookmark Links - Prompted Links - Guided Navigation - Static Links - Conditional Links - Briefing Books
15. Presentation CatalogPresentation Catalog Structure - Presentation Catalog Permission Types - Setting Permissions - Copying and Pasting between Catalogs - Moving a Presentation Catalog - Online Mode - Offline Mode - Migrating Presentation catalog Objects
16. OBIEE DeliversDelivers - Delivery Devices - Delivery Profiles - IBots - Alerts - General tab - Conditional Request tab - Schedule tab - Recipients tab - Delivery Content tab - Destinations tab - Advanced tab - Oracle BI Scheduler - Scripted Jobs- Job Manager – Log files
17. Performance TuningMaterialized views - RPD views - Outer Joins - Multiple sources- Aggregate tables - Partitioning Expressions - Pivot tables - Tables - cache - Ibots - Performance Tuning Reports -Performance Tuning - Mappings - cache - Filters - Efficient logic Implementation - Workflows Dependencies Bottlenecks - Source - Target - Mapping - Workflow - Usage of Indexes - Stored Procedures - Optimizing - Transformations - Databases - data type Conversions - Bulk Loading - SQL Tuning - Indexes
18. Oracle QueriesSelect statement - Distinct - Filters - Multiple columns - AND - OR - IN - LIKE - Operators - filters using NULL - BETWEEN - NOT IN - ALL - ANY - Filters using Functions - Join as a filter - Calculated Column used in Filter - ORDER BY - Arithmetic Functions - Date Functions - String Function - Conversion Function - Case - Decode - Connect by - Start with Clauses - NULL Value Behavior - Joins - Inner - Left Outer - Right Outer - Full Outer - Cartesian join - Table - Functions in Joins - Calculated column in joins(A+B=C) - Joins Using Date Functions
19. Advanced QueriesAggregate Functions - Nested Aggregation - GROUP BY Clause - HAVING - Aggregation using Calculated Columns - Inflation of values using aggregate tables - Sub Queries - Correlated Sub query - Inline View - Operators - UNION - MINUS - INTERSECT - UNION ALL - Joins, filters and sorting usage in Sub Queries - Nested Sub Queries - ROWNUM - ROWID - Execution Plan - DML Statements - Select - Insert - Update - Delete - Merge - Truncate - Analytic Functions - Configuring - Running - Moving Sum - Rank

20. Database ObjectsTables - Triggers - Types of Triggers - Views - Materialised View - Database Links - Sequences - Hints-Temporary Tables - External Tables - Indexes - Types of Indexes - Query Performance - With and Without Indexes - Locks - DDL Statements - Create - table - View - Index - Function - Objects - Rename - Alter - Change - Data types - Column length - Commit Security - Oracle System Tables - Usage
21. Oracle PL/SQLPL/SQL Overview - PL/SQL blocks - Declaring PL/SQL Identifiers - Variables - Executable Statements - Nested Blocks - Operators - Control Structures - Loops - Working with Composite Data Types - INDEX BY - Tables - Table Methods - Table of Records- Explicit Cursors - Handling Exceptions - Stored Procedures - Subprograms - Stored Functions - Packages - Compound Triggers - PL/SQL Compiler - Dependencies - Debugging
22. Oracle BI for MS Office and BI PublisherOracle BI for Microsoft Office - User Interface - Inserting Views -Microsoft PowerPoint - Microsoft Excel - Securing BI Data in Office - Refreshing - Oracle BI Publisher Reports - BI Publisher report - Data source - Template - Build - Upload - BI Publisher Report from BI Server - Query Builder - Associate - existing template
23. RDBMS and Data ModelingRDBMS Concepts - Database - Types of Keys - ER Model – Table Relationships - Normalisation - Types - Data integrity - Entity Integrity - Referential Integrity Primary key - Foreign Key relationship - Join types - Relationship (1:1 ,1:M and M:M) - Locks Normalised Schema - Dimensional Modeling - Basic Design Principles - OLTP Schema - Siebel Data Model - Base Table - Intersection Table - Audit Trail table - Transaction Tables - Non Transaction tables
24. Design LifecycleIdentify Business Process Requirements - Requirements Gathering - Analysis - Identify the Grain - Identify the Dimensions - Identify the Facts - Physical design considerations - Logical Data modeling - Physical Data modeling - ER modeling - Dimensional modeling - Types of Schemas - Star - Snow Flake - Multi Star Schema - Data ware House Design Approaches - Top Down approach - Bottom-Up Approach - Hybrid Approach
25. DimensionsDimension Definition - Types - Conformed Dimensions - Dimensional Hierarchies - Slowly changing dimensions - Types - Type 1 - Type 2 - Type 3 - Hybrid Types - Fast changing dimensions - Time Dimension - Garbage Dimensions - Role-Playing Dimensions - Multi-Valued Dimensions - Bridge Tables - Heterogeneous Dimensions - Hot Swappable Dimensions - Mini Dimension - Extension Tables - Casual Dimension

26. FactsFacts - Definition - Fact Table Design - Fact Table Types - Transaction Fact table - Periodic Fact Table - Event Fact tables - Fact less Fact Tables - Degenerate Dimension - Fact Table Granularity - Conformed Facts - Year-to-Date Facts - Non-Additive Facts - Semi-Additive Facts Textual Fact - Aggregate Tables - Multiple Granular Fact Tables - Fact Table Model for Slowly Changing Dimensions
27. Unix and Shell ScriptingPmcmd- Environment Variables - Command Line Mode - Interactive Mode- Command Parameters - Parameter Files – Schedule workflow – File Transfer Protocol (FTP) - pmrep and pmrepagent Commands - System Commands - Repository Commands - Security Commands
28. Data Warehousing Admin ConsoleArchitecture - Tables - Source/Target - Table Groups - Subject Area - Execution Plan - Image Tables - Indices - Defining Workflow - Configuring Dependencies - Truncate Option - Configuration - Full load/ Delta load - Change Capture Process - Tables- Views - SQL - Filter- Delete triggers - Configuring the DAC to load the delete rows - Image table for auxiliary tables Image flag - Auxiliary change capture process - Importing - Exporting Metadata - DAC Internal tables Properties - DAC Execute View - Execution Plan - Run History - Refresh Date - Prune days- Scripts - Change Capture- Generate Index- Query - Order of Execution
29. Informatica BasicsArchitecture - Components - Designer - Source Analyser - Warehouse Designer - Mapplets - Transformation - Mappings - Reusable Transformations - Import - source tables - Target Tables - Validate Mappings- Target Load order - Multiple Pipeline- Repository Manager - Creating Folders - Security - Sources - Relational - Flat files - Workflow Manager - Sessions - Worklets - Tasks - Workflows - Dependencies - Session logs - Scheduling - Workflow Monitor
30. DesignerOverview - Designer Tools - Shortcuts - Checking Out and In Versioned Repository Objects - Reverting to a Previous Object Version - Copying Designer Objects - Exporting and Importing Objects - Metadata Extensions - Debugger - Breakpoints - Running - Evaluating Expressions - Previewing Data - Relational Data - Flat File Data - Comparing Objects
31. Sources and TargetsSource Analyser - Warehouse Designer- Relational Sources - Flat Files - Import - Data Types - Workflow Properties - Connections - Relational Database - Treat Source Rows As - Flat files - Properties - Fixed-Width - Delimited - Null Character Handling- Numeric Data Handling - Dates- File List - Special Character Handling- Numeric Data Handling - Dates - Target Table Properties - Truncate - Deadlock Retry - Loading - Constraint Based - Bulk

32. Transformations
Overview - Ports - Multi group Transformations - Expressions - Local Variables - Capture Values from Stored Procedures - Variable Ports - Default Values for Ports - User Defined Default Values - Tracing Level - Reusable Transformations - Instances and Inherited Changes Mapping Variables in Expressions - Creating Non-Reusable Instances of Reusable Transformations - Editing Reusable Transformation
33. Mapplets and VariablesOverview - Mapplet Designer - Mapplets - Creating - Editing - Validating - Mapping Parameters - Mapping Variables - Initial and Default Values - String Parameters and Variables - Date time Parameters and Variables- Mapping Variables- Variable Data type and Aggregation Type- Variable Functions - Mapping Variables in Mapplet

34. Mappings
Mappings - Create - Open - Copy - Edit- Debug - Delete - Exporting - Importing - Copying Mapping Segments - Objects- Linking Ports -Position - Name - Rules - Connecting Mapping Objects - Source Column Dependencies - Dependencies in a Link Path - Implicit Dependencies Sources - Transformations - Reusable Transformations - Mapplets -Targets - Relational - Flat File - Target Load Order - Rejecting Truncated and Overflow Data - Target Update Override - Validating - Connection- Expression - Object - Data Flow
35. Siebel Data WarehouseTypes of Mappings - SDE Mapping - SIL Mappings - Unspecified Mappings - Auxiliary Mappings Delete Mappings - Update Mappings - Populating - Dimension tables- Fact tables - Slowly Changing Dimensions - Type1 - Type2 - Type3 - Aggregate tables - Sources - Relational - Flat files - Initial Load - Incremental load - Dependencies - Debugging Techniques - Procedure - Adding a New Table - Column - Hard delete - Soft Delete.

36. Source Qualifier Transformation
Overview - Transformation Data types - Target Load Order - Parameters and Variables -Default Query - Overriding - Joining Source Data - Heterogeneous Joins - Outer joins- Custom SQL Query - Filter- Sorted Ports - Distinct - Overriding Select Distinct in the Session - Pre SQL and Post-Session SQL- Indexes - Dropping and Recreating

37. Filter and Router Transformation
Filter Transformation - Creation - Filter Condition - Strings - Date - Numbers - Expression based Filter - Boolean Expressions - Operators - logical - String - Comparison - Router Transformation - Working with Groups - Input Group - Output Groups - Group Filter Conditions Adding Groups - Editing Groups - Ports - Handling Null values

38. Expression Transformation
Overview - Calculating Values - Multiple Calculations - Character Functions - Conversion Functions - Data Cleansing Functions - Date Functions - Numeric Functions - Scientific Functions - Special Functions - Test Functions - Variable Functions - Local Variables - System Variables - Boolean Expressions- Operator Precedence - Operators - logical - String - Comparison - Arithmetic -Dates - Relational Databases - Flat files - Handling Null values

39. Sequence Generator and Sorter Transformation
Sequence Generator Transformation - Common Uses - Creating Keys - Replacing Missing Values - Sequence Generator Ports - NEXTVAL - CURRVAL - Transformation Properties - Start Value and Cycle - Increment By - End Value - Current Value - Number of Cached Values - Reset - Sorter Transformation - Sorting Data - Properties - Sorter Cache Size - Case Sensitive Distinct Output Rows - Tracing Level - Null Treated Low

40. Joiner and Union Transformation
Joiner Transformation Properties - Join Condition - Join Type-Normal Join - Master Outer Join Detail Outer Join - Full Outer Join - Cartesian Join - Using Sorted Input - Joining Data - Multiple Sources - Same Source - Caching - Blocking the Source Pipelines - Union Transformation - Create - Components - Groups and Ports - Edit - Properties

41. Normalizer and Rank Transformation
Normalizer Transformation - Properties - Normalizing Data in a Mapping- Normalizer Ports - Converting Rows into Columns - Rank Transformation - Ranking String Values - Rank Caches Properties - Ports - Rank Index - Groups

42. Aggregator Transformation
Aggregator Transformation - Ports - Components - Aggregate Caches - Aggregate Expressions Functions - Nested Aggregate Functions - Conditional Clauses - Non Aggregate Functions - Null Values - Group By Ports - Non Aggregate Expressions Default Values - Using Sorted Input Incremental Aggregation - Aggregate Files - Reinitializing - Moving or Deleting

43. Lookup Transformation
Lookup Transformation - Connected - Unconnected Lookups - Relational and Flat File Lookups Components - Ports - Properties- Lookup Condition - Lookup Properties in a Session Overriding the Lookup Query - Uncached or Static Cache - Dynamic Cache - Lookup Caches - Call the Lookup - Expression - Persistent Lookup Cache - Non-Persistent Cache - NewLookupRow Port Associated Input Port - Lookup Transformation Values - Update Strategy Transformations with Dynamic Cache - Dynamic Lookup Cache - Updating - WHERE Clause - Synchronizing - Sharing - Lookup Cache- Unnamed Lookup Cache - Named Lookup Cache

44. Stored Procedure Transformation
Stored Procedure Transformation - Input and Output Data - Connected and Unconnected-
Scheduling - Importing Stored Procedures-Setting Options for the Stored Procedure -Using $Source and $Target Variables - Calling a Stored Procedure from an Expression - Calling a Pre- or Post-Session Stored Procedure -Error Handling -Pre-Session Errors - Post-Session Errors - Session Errors -Supported Databases -Expression Rules

45. Update Strategy Transformation
Update Strategy Transformation - Setting the Update Strategy - Flagging Rows Within a Mapping - Forwarding Rejected Rows - Update Strategy Expressions - Aggregator and Update Strategy Transformations - Lookup and Update Strategy Transformations - Setting the Update Strategy for a Session - Specifying an Operation for All Rows - Specifying Operations for Individual Target Tables-Update Strategy Checklist

46. Workflow Manager
Overview - General Options - Format Options - Miscellaneous Options - Server Variables - Registering a Power Center Server - Connection Object Permissions - Relational Database Connection - Configuring Environment SQL - Tasks - Repository Objects - Checking Out and In Versioned Repository Objects - Comparing Repository Objects - Metadata Extensions

47. Workflows and Worklets
Workflows - Privileges - Tasks - Links - Expression Editor - Variables - Scheduling a Workflow - Reusable Scheduler - Scheduler Settings - Validation - Workflow - Running – Suspending - Disabling - Worklets - Reusable - Non-Reusable - Tasks - Variables - Persistent Worklet Variables - Overriding Initial Value - Worklets - Nesting - Validating - Suspending

48. Tasks
Overview - Creating a Task -Configuring - Reusable Workflow Tasks-AND or OR Input Links Disabling Tasks - Failing Parent Workflow or Worklet - Validating Tasks - Assignment Task Command Task - Executing Commands - Session Parameters - Control Task - Decision Task Event Tasks - Event-Raise Tasks-Event - Wait Tasks - Timer Task

49. Sessions
Session - Create - Pre- and Post-Session SQL Commands - Using Server and Session Variables Validating - Session - Running - Stopping - Aborting - Errors - ABORT Function - Mapping Parameters and Variables - Handling High Precision Data - Session Caches - Memory Cache - Cache Files - Cache Calculations - Cache Partitioning - Aggregator Caches - Joiner Caches - Lookup Caches - Static Cache - Dynamic Cache - Sharing Partitioned Caches - Rank Caches
50. Workflow Monitor and Repository ManagerWorkflow Monitor- Customizing Workflow Monitor Options - Toolbars-Working with Tasks and Workflows - Workflow and Task Status - Gantt Chart View - Task View - Monitoring Session Details - Creating and Viewing Performance Details- Repository Manager - Managing the Repository - Folders - Exporting and Importing Objects - Locks - Back up Repository - Validating Mappings - Workflows - Comparing Repository Objects - Version control