Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with data-warehouse
Search options answers only
not deleted
user 23721
A database system optimised for reporting, particularly in aggregate. Often, but not always implemented using a star schema.
3
votes
Accepted
Why student attendance is not considered a fact in data warehousing?
Blame Kimball for the confusing term. Attendance is a fact (as in, "a thing that is known or proved to be true"). However, it is an event, and as such it does not have any extra information apart from …
- 26.9k
2
votes
Accepted
How does Data Warehousing work in reverse?
This question is a bit too broad for a definitive answer, because there are endless possibilities for data to flow in all sorts of directions between various data stores. I also find it strange that t …
- 26.9k
3
votes
What are the disadadvantages of a datawarehouse with no datawarehouse tables, but only datam...
The purpose of the data warehouse is to serve as a single source of truth1 for your BI consumers. It provides you with the central place where the data and metadata for your reports and dashboards ori …
- 26.9k
3
votes
Accepted
How much RAM should I get for a cloud-hosted PostgreSQL data warehouse?
Estimating database server memory size by the size of tables (or indexes) is going to be misleading. On the one hand, depending on the database workload, it may not ever need to load the entire table …
- 26.9k
1
vote
In a data warehouse, should a measure be based on a fact or a dimension?
The problem with contrived examples like the one you provide is that whatever answer you find, it won't be helpful in a real life situation. "A number of distinct customers" is useless as a measure, b …
- 26.9k
3
votes
Accepted
Is "ETL vs ELT" just "tables vs views"?
No.
What you describe are all variants of ELT.
The difference between ETL and ELT is in where you do the "T". The "traditional" ETL flow would implement the "T" (data transformation) outside the DBMS, …
- 26.9k
1
vote
how do modern data warehouses tackle frequent small writes? esp. when streaming data is one ...
Data warehouse is a concept, not a product, so the primary question, "how do modern data warehouses tackle <whatever>" is this: however you design them.
To date, in my opinion, none of the major DBMSe …
- 26.9k
1
vote
From what volumes of data do data ingestion tools like apache nifi, flume, storm or tools li...
Data volume is one of the last criteria for choosing the ingestion pipeline implementation. You choose the tool for what it can do that your current tool cannot, and then you test it to see if can han …
- 26.9k
2
votes
Accepted
How can Amazon Redshift be built based on PostgreSQL if Postgres is row-based?
A Postgres server is a lot of things, not just row-oriented access methods:
(The image above is from the Postgres documentation.)
Postgres source code is available for anyone to use under a very perm …
- 26.9k
2
votes
Accepted
Datawarehouse Staging Tables: Null or Not Null
I don't see what benefit you can draw from not having constraints. The only scenario when you can consider dropping the NOT NULL constraints is if your ETL process loads data in several steps and at s …
- 26.9k
3
votes
How to prevent users other than DBAs from creating database links
I think you are approaching this from the wrong end. A database link includes the user ID and password to connect to the remote server; if the user ID does not exists on the remote server or is not al …
- 26.9k