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 data-warehouse
How Do I aggregate Data By Day and Still Respect Timezone?
Jun 10, 2019
sql
database
database-design
data-warehouse
date/time dimension
Nov 02, 2022
sql
data-warehouse
dimensions
Is it possible to partially refresh a materialized view in Oracle?
Oct 24, 2022
oracle
data-warehouse
partitioning
materialized-views
How to calculate Azure SQL Data Warehouse DWU?
Apr 16, 2022
azure
data-warehouse
azure-sqldw
Database warehouse design: fact tables and dimension tables
Oct 12, 2019
sql
database-design
data-warehouse
olap
Generating star schema in hive
Oct 18, 2022
hadoop
hive
data-warehouse
dimensional-modeling
fact
How to create history fact table?
Nov 17, 2022
sql
data-warehouse
fact-table
datahistory
Star schema, normalized dimensions, denormalized hierarchy level keys
Nov 17, 2022
data-modeling
data-warehouse
database-normalization
star-schema
data.cube
Database architecture for millions of new rows per day
Sep 21, 2019
mysql
database
scalability
analytics
data-warehouse
Is star schema still necessary for a big-data-warehouse?
Oct 24, 2022
hadoop
hive
data-warehouse
How to test (unit test) on ETL process?
Oct 18, 2022
testing
etl
data-warehouse
What should I have in mind when building OLAP solution from scratch?
Jan 01, 2019
sql-server
ssis
data-warehouse
olap
business-intelligence
Why primary key is (not) required on fact table in dimensional modelling?
Jan 31, 2022
database-design
primary-key
data-warehouse
fact-table
Database - fact table and dimension table
Nov 05, 2022
database
data-warehouse
business-intelligence
What is the actual difference between Data Warehouse & Big Data?
Nov 06, 2022
database
bigdata
data-warehouse
What does "incremental load" mean?
Sep 22, 2022
database
terminology
data-warehouse
SSIS - OLE DB Destination - Table or Views load vs. Fast-load
Apr 09, 2022
ssis
sql-server-2008-r2
data-warehouse
Calendar table for Data Warehouse
Oct 27, 2022
sql-server
data-warehouse
ETL using Python
Jul 29, 2019
python
data-warehouse
etl
Using a DATE field as primary key of a date dimension with MySQL
Sep 22, 2022
mysql
date
schema
data-warehouse
dimension
« Newer Entries
Older Entries »
Menu