Question : Myself and another DBA at our company are tasked with reviewing a database design that a vendor has […]
Tag: facttable
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 […]
How to check if there is partitions in use in fact tables?
Question : I’m going to take a first look of a large data warehouse with many fact tables. How can […]
If a DW fact table is not uniquely identified by all dimensions, what problems?
Question : This is a bit of a thought problem I’ve been wrestling with. I have a visceral antipathy to […]
- 1
- 2