Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in data-warehouse

Insert into a star-schema

EDW Kimball vs Inmon

data-warehouse

What's the Grain in the context of DW

Handling multiple fact tables in Qlikview

Subtract two dates in Microsoft SQL Server

Avoid writing SQL queries altogether in SSIS

data-warehouse ssis

In a star schema, are foreign key constraints between facts and dimensions neccessary?

Anything similar to MySQL Proxy for PostgreSQL? [closed]

Data Warehousing arbitrary fields

Implementing roleplaying dimension with friendly attribute names in SSAS?

ssas data-warehouse

Difference between Transactional and Reporting Database

In a Data Warehouse scenario is there any disadvantage to using WITH(NOLOCK)

Oracle aggregation function to allocate amount

True or False: Good design calls for every table to have a primary key, if nothing else, a running integer

What is best practice for representing time intervals in a data warehouse?

What difference of RDBMS and Hive? [closed]

sql hadoop data-warehouse hive

Is a fact table in normalized or de-normalized form?

Good place to start learning data warehousing? [closed]

resources data-warehouse

Can you recommend a good source for Teradata Best Practices?

sql data-warehouse teradata

How to do Real-time loading into Amazon Redshift?