Questions
Linux
Laravel
Mysql
Ubuntu
Git
Menu
HTML
CSS
JAVASCRIPT
SQL
PYTHON
PHP
BOOTSTRAP
JAVA
JQUERY
R
React
Kotlin
×
Linux
Laravel
Mysql
Ubuntu
Git
New posts in dimensional-modeling
Why should we separate dimension and facts instead of combining both in one table
Dec 27, 2022
data-warehouse
dimensional-modeling
star-schema
Type II SCD with entities that merge over time
Nov 14, 2022
data-warehouse
dimensional-modeling
scd
type-2-dimension
How to handle late arriving dimension and NULL business key in Kimball Data Mart?
Oct 08, 2022
sql
sql-server
database-design
data-warehouse
dimensional-modeling
Dimensional Modelling
Oct 06, 2022
sql-server-2012
data-warehouse
dimensional-modeling
Naming standards for dimensional modeling
Oct 19, 2022
data-warehouse
dimensional-modeling
Is facts table in dimensional model is actually a table of events?
Nov 12, 2022
database
data-modeling
data-warehouse
dimensional-modeling
Why we use Dimensional Model over Denormalized relational Model?
Oct 15, 2022
relational-database
database-schema
denormalization
dimensional-modeling
oltp
Why NULL values are mapped as 0 in Fact tables?
Aug 17, 2022
sql-server
ssis
null
data-warehouse
dimensional-modeling
audit table vs. Type 2 Slowly Changing Dimension
Sep 05, 2022
sql
sql-server-2008
data-modeling
dimensional-modeling
scd
Dimension for geozones or Lat & Long in data warehouse
Oct 07, 2017
sql-server
data-warehouse
dimensional-modeling
How to design a shrunken dimension table for dates in dimensional warehouse and use in SSAS?
Nov 15, 2022
sql-server
ssas
data-warehouse
business-intelligence
dimensional-modeling
Dimension row with multiple attributes
Aug 17, 2022
sql
tsql
database-design
data-warehouse
dimensional-modeling
Redshift Performance of Flat Tables Vs Dimension and Facts
Aug 29, 2022
amazon-redshift
data-warehouse
dimensional-modeling
joining across multiple fact tables with a dimension in between
May 06, 2022
sql-server
data-warehouse
business-intelligence
dimension
dimensional-modeling
What's the Grain in the context of DW
Feb 16, 2022
sql
database
oracle
data-warehouse
dimensional-modeling
Handling multiple fact tables in Qlikview
Dec 13, 2019
database
database-design
data-warehouse
qlikview
dimensional-modeling
Dimensional Modelling - ambiguous relations
May 22, 2021
powerbi
dimensional-modeling
Generating star schema in hive
Oct 18, 2022
hadoop
hive
data-warehouse
dimensional-modeling
fact
Older Entries »
Menu