Central Data warehouseA Central Data Warehouse is a repository of company data where a database is created from operational data extracts. This database adheres to a single, consistent enterprise data model to ensure consistency in decision making support across the company.Active Metadata WarehouseAn Active Metadata Warehouse is a repository of Metadata to help speed up data reporting and analyses from an active data warehouse....
Subscribe To
Posts
All Comments
Sunday, September 14, 2008
Friday, September 12, 2008
ODS Vs. Data Warehouse
ODS Vs. Data WarehouseOperational Data store- Data Focused Integration From Transaction Processing Focused Systems - Age Of The Data is Current, Near Term (Today, Last Week’s)- Primary Use: Day-To-Day Decisions Tactical Reporting Current Operational Results - Frequency Of Load: Twice Daily , Daily, WeeklyDatawarehouse- Subject Oriented,Integrated,Non-Volatile,Time Variant- Age of the Data is Historic (Last Month, Qtrly,...
Tuesday, September 2, 2008
Incompatible objects
Incompatible objects nothing but Sometimes it is not possible to use certain combinations of objects in data providers. This situation arises when objects bear no relationship to one another. These objects are called incompatible objects.For example, the Island Resorts Marketing universe contains the[Reservation Year] and [Revenue] objects, which are incompatible. This isbecause there is no revenue associated with a reservation....
What is a scope of analysis?
The scope of analysis for a query is extra data that you can retrieve from thedatabase to give more details on the data returned by each of the objects in aquery. This extra data does not appear in the initial result document, but itremains available in the data cube, so you can pull this data in to the report toallow you to access more detail at any time. This process of refining the datato lower levels of detail is called drilling...
Monday, August 18, 2008
Views, Oracle
What is View?A view is a logical table based on a table or another view. A view contains no data of its own but is like a window through which data from tables can be viewed or changed. The tables on which a view is based are called base tables. The view is stored as a SELECT statement in the DD.Advantages of views;->View restrict access to data bcz the view can display selective columns from the table.->View can be used...
Sunday, August 3, 2008
Subscribe to:
Posts (Atom)
Popular Posts
-
Introduction to Semantic Layers The semantic layer is a metadata layer that abstracts the complexities of the data source. The end user see...
-
Designer lets you save universes in either enterprise or workgroup mode. Enterprise mode means that you are working in an environment with a...
-
Define what a Loop is Detect and recognize loops in Universe Using Aliases and Contexts to resolve the loops Identify when in the design ...
