Stack Overflow
Stack Overflow

Questions tagged [star-schema-datawarehouse]

What are the characteristics of Star Schema Data warehouse ?

  • Every dimension in a star schema is represented with the only one-dimension table having a Surrogate Key and a Business Key.
  • The dimension table should contain a set of specific attributes.
  • The dimension table is joined to the fact table using a foreign key.
  • The dimension table are not joined to each other.
  • Fact table contains Surrogate Keys and measures

The Star Schema is the easiest to understand and provides optimal usage for physical ressources.

46 questions
2
votes
1 answer

Multiple sources for dimensions in Data Warehouse

I am currently working on a financial Risk data warehouse. For my collateral dimension, I am souring the data from one source system. However, after further research by the business analyst, we found a legacy application that also holds collateral…
Eseosa Omoregie
  • 175
  • 2
  • 11
2
votes
1 answer

From operational data store to warehouse

I have 3 ODS, so in order to create DWH, do I need a DWH for each ODSs, or the DWH select the tables from any of the ODSs?
Ahmed Algosaibi
  • 31
  • 5
2
votes
0 answers

Dimension model (recursive / hierarchical) for Data Warehouse

I'm having difficulty connecting a dimension table (recursive/hierarchical) to a fact table as there are concerns/issues to deal with: The dimension table belongs to a parent-child relationship structure From the original table, it keeps…
zysirhc
  • 37
  • 7
2
votes
1 answer

Snowflake Database with Dimensional modelling(Star Schema)

We know that Snowflake is a compressed columnar storage database and tuned to run queries with MPP and auto scaling. We also know that for creating data marts and DW, Kimball and Dimensional modelling(Star Schema) has been in market and practice…
Amit Mahapatra
  • 21
  • 2
2
votes
0 answers

Best practices for fact table that depends on two processes

I am building a star schema for an online business. One of the key processes is email newsletter signup. But the analysis depends on two processes and I can't figure out how to model it the best way. Here's how the process works: Person visits…
user3505886
  • 710
  • 7
  • 7
1
vote
1 answer

PostgreSQL ON CONFLICT add new entry with new timestamp

I'm trying to make a star schema using postgresql. My issue is that when I get a new entry with a changed e-mail but have the same unique name then I want have an ON CONFLICT to insert the row and just update the timestamp. But I can see that you…
TYKitnap
  • 13
  • 3
1
vote
0 answers

Dimension Fact tables issue

Have the following Task and i don't know how to deal with: Orders Customers Shipments Warehouses The requirements are: Every Order includes different products and have only one customer Every Customer can have more than one address and it can be…
Jony_Junior
  • 35
  • 6
1
vote
0 answers

How to handle Manual Input within your Data Warehouse

I newly joined an organisation and we recently introduced a Data Warehouse solution (Snowflake) that incorporates a large amount of external systems (CRM etc). There are use cases to bring manual data input on weekly (e.i. Sales targets ). This one…
timy
  • 97
  • 6
1
vote
0 answers

How can I make sure every change to dimension is captured in SCD2?

I work for a finance company. We need to track exact value dimensions at the time of the transaction. We try to load data incrementally into the warehouse ~ 15 mins, and in this period, we could see a dimension with the exact business key change…
user16344431
1
vote
1 answer

How to get the correct table as a Fact Table with relevant keys?(Star Schema)

I have a problem to select the suitable table for the fact table. I have problem with following two tables OrderData Table…
user12760080
  • 11
  • 3
1
vote
1 answer

Type 2 Slowly Changing Dimensions and Querying for Historical data at a point in time

I have a small star schema representing time entries for issues in Jira. I have an IssueAttributes type 2 dimension table, and then a TimeEntry fact table. Simplified view of dimension…
hyphen
  • 2,368
  • 5
  • 28
  • 59
1
vote
0 answers

how to create snowflake schema from this database?

i try to create a snowflake schema from this: and I try to make that so please help me for develop my snow Flake schema and tell me what is wrong in this and how to make it better ....
sandra
  • 23
  • 5
1
vote
1 answer

What is meant by fact values or measure in fact table?

I have strong confusion with fact values, is it derived directly from OLTP by ETL mechanism into fact table & then we need to perform aggregate function to get summarized that by throwing queries? Or it is nothing but summarized value that we get…
rushikesh ayati
  • 17
  • 1
  • 6
0
votes
0 answers

PostgreSQL as OLAP setup

I am trying to setup postgresql to use OLAP benefits as my current OLTP db is no more required, hence i want to move it to OLAP system for genrating reports as there would not be much transactions where as onlny reporting and other warehouse…
Amit
  • 31
  • 1
0
votes
0 answers

Views or Tables in Power BI

This is a fundamental architecture question for Power BI. I have developed star schemas for years and now my job is wanting me to go into the UI world as well. I want to start off correctly, so I was wondering if I should create views and import…
SurfingViolinist
  • 51
  • 5
1
2 3 4