data-warehouse

83 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How to generate point in time snapshot table from a transaction fact table?
user_27720610
•
2
2
252
data-warehouse oracle sql
What is the best practice for placement of incremental models in DBT pipelines?
user_23075230
•
1
0
235
bigdata dbt snowflake-cloud-data-platform data-warehouse
Materialized view is not showing up in plan table output from explain plan statement spool?
user_151852190
•
1
1
98
data-warehouse oracle11g plsql oracle
Dimension model (recursive / hierarchical) for Data Warehouse
user_121300180
•
2
0
359
sql-data-warehouse kimball star-schema-datawarehouse data-warehouse data-modeling
After copying all our SQL, NoSQL data into Snowflake, is there a way to detect "relationships" across the hundreds of Tables, Jsons, other data?
user_150968260
•
4
1
98
snowflake-cloud-data-platform data-warehouse data-modeling sql
String delimiter present in string not permitted in Polybase?
user_33963510
•
2
2
659
polybase data-warehouse sql-server
When do we consider snowflaking a star schema?
user_144584740
•
2
1
77
snowflake-schema etl star-schema data-warehouse data-modeling
Data Modeling with a Time Dimension
user_55608980
•
3
3
411
business-intelligence data-warehouse data-modeling
Why would I not used Databricks as my data mart?
user_116794160
•
3
1
339
datamart databricks data-warehouse
Put hierarchy in its own separate dimension or set it as a part of related dimension?
user_4183430
•
2
2
553
business-intelligence dimensional-modeling data-warehouse sql-server sql
Hot Questions