Appropriate use of materialized views

Understanding Materialized Views as aggregate tables

Hello I have to provide a count and I am using a materialized view in sql 2008 as an aggregate table. My issue is understanding how the count will work. I need a count by 3 different categories (Product, Type, and TypeName). So....should that field be

Best method to track deleted records on source in Oracle

We need a way to track deleted records from the source tables in Oracle. We have one source Oracle database and our data warehouse is also in Oracle. I'm somewhat familiar with CDC (asynchronous would do the job) to tap into the logs, but is there anythin

library views

is there a way i can sort movies by file name in library view? as i name my movies so series are together, batman begins and the dark night are Batman Nolan 01 - Batman Begins and Batman Nolan 02 - The Dark Knight but in library views they are

Too many Time Dimension Role Views?

I have a question about date fields and the time dimension. We have an Order Detail fact table that has about 10 date fields. We're not sure how best to handle these with regards to joining them to the "Time" dimension. If we strictly

Dimension Attributes and Fact attributes storing same data in multiple data marts??

Can data marts using BUS architecture store the same data but be called different names like DimChargeToDept and DimDepartment. All have the same attirbutes names different but same exact data and rows. I would rather they create a view for each

four-firm alliance and to meet with Maliki Balbarzani again will contribute to the activation

Writer: the four-firm alliance and to meet with Maliki Balbarzani again will contribute to the activation 30/7/2009 - 19:26 BAGHDAD / Aswat al-Iraq: A leader of the Islamic Dawa Party, Ali al-Adeeb, on Thursday, that his party remains committed to

Kuwaiti-Omani relations "model" of effective GCC cooperation -- official

Kuwaiti-Omani relations "model" of effective GCC cooperation -- official Politics 12/16/2009 3:16:00 PM MUSCAT, Dec 16 (KUNA) -- Kuwaiti Ambassador to Oman Shamlan Al-Roumi affirmed here Wednesday the strong relations between Kuwait and

Montly Snapshot views with transactional Fact table w/SCD2

I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with

United Nations form a committee to bring the views on the disputed areas

United Nations form a committee to bring the views on the disputed areas By: mano Date: Monday 07/02/2011 10:09 Baghdad (news) .. MP for the Iraqi List, AGIL Hamidi Ajil the formation of a committee of the United Nations to bridge the ga

Dimensional Model Vs Views as Structure for BOBJ Universe

I have a fairly complex data mart (multiple fact tables: 5 at the moment and several more coming; 4 shared dimensions across the 5 facts, 26 total dimensions and several bridge tables). I used standard best practices for building the Business Objects

Too many Time Dimension Role Views?

I have a question about date fields and the time dimension. We have an Order Detail fact table that has about 10 date fields. We're not sure how best to handle these with regards to joining them to the "Time" dimension. If we strictly

Franz Ferdinand

Another really cool band I know. While Spoon is the more contemplative in my list of favorite bands (and my all time favorite) Franz is the more energy-based music in my playlist. From the UK, they have an amazing assortment of Catchy tunes I promise

fact table as a dimension

Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both