Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Creating Database View on Fact Table with Dimension tables

2 posters

Go down

Creating Database View on Fact Table with Dimension tables Empty Creating Database View on Fact Table with Dimension tables

Post  vijaykodia Fri Dec 12, 2014 11:28 am

Is it good idea to get max date data from a Fact table joining one dimension v/s creating materialized view? What happens if there is bit map index on a fact table if data is not retrieved directly on Fact Table but instead fetch data by creating database view? The question is query max date data directly using Fact Table joining Dimension tables or create database view and use database view to create materialized view to query further.

vijaykodia

Posts : 1
Join date : 2014-12-12

Back to top Go down

Creating Database View on Fact Table with Dimension tables Empty Re: Creating Database View on Fact Table with Dimension tables

Post  ngalemmo Fri Dec 12, 2014 1:54 pm

Just query the table. If you find there are performance issues and it is a frequent query, then start considering alternatives. There are a lot of ways to deal with it depending on use cases you will encounter.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum