Question : I have a fact table with the user reservations with StartDate and EndDate. I am thinking what is […]
Tag: facttable
How to design this kind of relations in a database
Question : I have a conceptual problem and I would like to get your ideas on how I’ll be able […]
Is my understanding of Fact table granularity correct?
Question : Myself and another DBA at our company are tasked with reviewing a database design that a vendor has […]
Conceptual Design of a data warehouse (declaring the grain)
Question : I am trying to design a data warehouse using this example scrubbed data. I need to declare the […]
Design of fact table(s) and dimensions tables for data warehouse
Question : Hi i’m newbie in Datawarehousing, how would you model this in a Data Warehouse: i wish design the […]
Improve performance of a Fact Table
Question : I have a Fact table CardTransactionFact Table Structure TABLE [dbo].[CardTransactionFact] [CardTransactionID] [int] IDENTITY(1,1) NOT NULL, [TransactionTerminalID] [int] NOT […]
Improve performance of a Fact Table
Question : I have a Fact table CardTransactionFact Table Structure TABLE [dbo].[CardTransactionFact] [CardTransactionID] [int] IDENTITY(1,1) NOT NULL, [TransactionTerminalID] [int] NOT […]
Database design to record occurences in tv show
Question : I want to make a database where I record the guests of each episodes of a tv show. […]
Header and line item data source mismatch
Question : I’m working with a star schema for a data warehouse and I am running into a problem with […]
Type of Foreign Keys for a Dimensional Model Fact Table?
Question : I’ve been reading about dimensional models, and in particular fact tables, but I haven’t really seen one in […]
- 1
- 2