Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in data-warehouse

Do I need to remove indexes on a table before a large load?

Dimensional Modeling: should a fact table have a foreign key?

How to write these two queries for a simple data warehouse, using ANSI SQL?

sql data-warehouse ansi-sql

Data Vault Hubs from different sources

What are the types of dimension tables in star schema design? [closed]

Informatica writes rejected rows into a bad file, how to avoid that?

Update using CASE statements on INNER join

Dynamic calculations in a materialized view

Update table1 based on value from table 2 in teradata

sql data-warehouse teradata

How to handle data vault hubs with no business key?

Data caching techniques / Tips / AppFabric

Generating ODI Packages

Analytic / Reporting - same or separate database, and which DB?

Need help with SQL aggregation query

Exporting Data to Excel file From Sql Server 2014 using SSIS 2012

Save Azure blob storage filename to Sql table - Azure Data Factory

azure data-warehouse

How to pull data with ETL stored procedure using SQL Server

Difference among Dimension, Dimension attribute and Facts

database data-warehouse