Authors: "Guna Vasireddy - Oracle","Sai Rajendra Vadakattu - Oracle ", "Ankur Jain - Oracle" Replicating Table without Primary Key Replicating Views...
Authors: "Guna Vasireddy - Oracle","Sai Rajendra Vadakattu - Oracle ", "Ankur Jain - Oracle" Replicating Table without Primary Key Replicating Views Replicating OLTP Packages Replicating Table without Primary Key: Use Case: Customer is using Oracle Golden Gate (OGG) to replicate the Source to SDS and would like to configure BIAPPS to use the SDS instead of the Source. Note: The SDS table differs from the source table in primarily two things: BIAPPS expects CDC columns...
Authors: "Guna Vasireddy - Oracle","Sai Rajendra Vadakattu - Oracle ", "Ankur Jain - Oracle" Replicating Table without Primary Key Replicating Views Replicating OLTP Packages Replicating Table...
Applies to OTBI-Enterprise Version 2 PB 2 TABLE OF CONTENTS Overview of the External Data Support Feature. 3 Support for On-Premise Oracle AU sources. 3...
Applies to OTBI-Enterprise Version 2 PB 2 TABLE OF CONTENTS Overview of the External Data Support Feature. 3 Support for On-Premise Oracle AU sources. 3 Support for Non-Oracle sources. 4 Supported Subject Areas – HCM+. 4 Practical Use Cases. 5 Getting Started with External Data – Oracle AU Sources. 5 Sequence of Steps – High Level 6 Deep Dive into the Actual Steps. 6 Register Source and Configure Storage Service Container. 6 Build Load Plans. 8 Prepare Data Files and...
Applies to OTBI-Enterprise Version 2 PB 2 TABLE OF CONTENTS Overview of the External Data Support Feature. 3 Support for On-Premise Oracle AU sources. 3 Support for Non-Oracle sources. 4 Supported...
Authored by : Manjunath Gangadhar Overview UOM or Unit Of Measure is the method of expressing the quantity of an item so that it can be tracked and accounted...
Authored by : Manjunath Gangadhar Overview UOM or Unit Of Measure is the method of expressing the quantity of an item so that it can be tracked and accounted for in a system. A data warehouse that stores and analyzes Items or Products must have a UOM standard defined. This post describes OBIA requirements, design and implementation of UOM What is UOM Conversion Let’s start with an example: Let’s say on 15th Jan, 2013 100 Ea of Mont Blanc pens were sold. Here Ea is Each which...
Authored by : Manjunath Gangadhar Overview UOM or Unit Of Measure is the method of expressing the quantity of an item so that it can be tracked and accounted for in a system. A data warehouse...
Authored by Vijay Aggarwal and Hichem Sellami A typical data warehouse contains Star and/or Snowflake schema, made up of Dimensions and Facts. The facts store...
Authored by Vijay Aggarwal and Hichem Sellami A typical data warehouse contains Star and/or Snowflake schema, made up of Dimensions and Facts. The facts store various numerical information including amounts. Example; Order Amount, Invoice Amount etc. With the true global nature of business now-a-days, the end-users want to view the reports in their own currency or in global/common currency as defined by their business. This presents a unique opportunity in BI to provide the...
Authored by Vijay Aggarwal and Hichem Sellami A typical data warehouse contains Star and/or Snowflake schema, made up of Dimensions and Facts. The facts store various numerical information including...