Tags » Data Warehouse

Object Oriented Programming approach in OBIEE - LTS Overriding - Part 2

We had discussed in my previous post here about one real life project scenario where we need to build a report with mixed granularity (e.g. report will have Order Detail and Product detail), but the same time your data model should be consistent and perform (report data returning time) well enough to support simplest form of report (e.g. 440 more words

Real Life Project Problem

Object Oriented Programming approach in OBIEE - LTS Overriding - Part 1

In this topic we are going to discuss about a particular usage of OBIEE Logical Table Source and how that relates to Object Oriented Programming. So a very high level conceptual understanding of OOP is preferable but not mandatory. 801 more words

Real Life Project Problem

Who Should Lead Your Enterprise Big Data Program? (Part 2 of 4)

(Author’s note: I missed this week’s “Hump Day” and am publishing this post on Thursday…so I guess that makes this week’s post “Over the Hump Day Analytics” :-)   ) 1,073 more words

Analytics

How to achieve almost 100% availability of BI reports even if when ETL is running - Synonym Toggling Technique - Part 2

We have discussed about concepts and a bit of theory behind synonym toggling in my previous post here.

In this post we would like to discuss about the technique of achieving this . 350 more words

Real Life Project Problem

How to achieve almost 100% availability of BI reports even if when ETL is running - Synonym Toggling Technique - Part 1

We often see in BI Data warehouse projects, few mission critical reports across the whole reporting system. And those reports needs much more frequent data refresh as well. 575 more words

Data Warehouse

Loading Excel File into RED Warehouse

   

WhereScape RED can access and load into warehouse virtually any type of data.

One of the most common sources that data loaded from is Excel file. 19 more words

Data Warehouse

Creating Oracle Database Link

Database Links

A database link is a connection between two physical database servers that allows a client to access them as one logical database. That means that in the same query is possible to access to different database. 107 more words

Data Warehouse