The facttable tag has no wiki summary.
6
votes
3answers
163 views
Header and line item data source mismatch
I'm working with a star schema for a data warehouse and I am running into a problem with header and line items from different data sources.
CREATE TABLE DataSourceAHeader
(
OrderId INT NOT NULL
...
1
vote
1answer
79 views
Conceptual Design of a data warehouse (declaring the grain)
I am trying to design a data warehouse using this example scrubbed data. I need to declare the "grain". I know its the lowest level of detail in the fact table, but I am having a hard time determining ...
2
votes
2answers
95 views
Open source and commercial tools to build dynamic queries of fact tables in star schema
What user interfaces or tools (commercial and/or open source) can query a star schema model (Ralph Kimball dimensional model)? So for example, if we have X fact tables, and Y dimension tables, and Z ...
1
vote
2answers
136 views
Data warehouse support tickets
I'm starting to design a data warehouse for a company. The first questions we're trying to resolve are regarding their support ticketing system. My initial schema is as follows
Now one of the ...
0
votes
1answer
63 views
How to design this kind of relations in a database
I have a conceptual problem and I would like to get your ideas on how I'll be able to do what I am aiming.
My goal is to create a database with information of persons who work at a place depending on ...
1
vote
2answers
97 views
How to check if there is partitions in use in fact tables?
I'm going to take a first look of a large data warehouse with many fact tables. How can I easily check if there is partitions and partition functions in use in these fact tables?
2
votes
1answer
356 views
Does surrogate key assignment for a fact table require that the source data has natural keys?
Let's say I have a simple OLTP database with orders, products, and customers:
And from it, I am building a data mart with an orders fact table, product dimension, customer dimension, and date ...
1
vote
3answers
383 views
Improve performance of a Fact Table
I have a Fact table CardTransactionFact
Table Structure
TABLE [dbo].[CardTransactionFact]
[CardTransactionID] [int] IDENTITY(1,1) NOT NULL,
[TransactionTerminalID] [int] NOT NULL,
...
3
votes
3answers
359 views
How do you roll up header-level values on a fact table with line-item granularity?
From what I've read, the recommended granularity for a fact table based on an order header / line item structure is at the line item level. In the process, any additive values that apply only to the ...
0
votes
1answer
584 views
SSAS -> New cube contains two fact tables. How do I relate these so I can use measures from both at the same time?
I am working on a new cube. I know that you cannot directly create a relationship between two fact tables (and expect good results).
I am just wondering how to go about doing this I have read ...
1
vote
1answer
540 views
Design of fact table(s) and dimensions tables for data warehouse
Hi i'm newbie in Datawarehousing, how would you model this in a Data Warehouse:
i wish design the Data Warehouse which give the answers of statistics relating to a baseball league
For players
in ...
1
vote
1answer
447 views
An advice to design a fact table with a scd as a dimension
I have a problem of conception and I would like to get your ideas on how I'll be able to do what I am aiming.
My goal is to create a datawarehouse, with three dimensions and one fact table so far.
...
