SQL Server join or Pentaho Spoon lookup?...

Generating MIS reports and dashboards using opensource technologies...

Data warehouse dimension design, customer and contact...

DWH not a Star-Schema not a Snow flake not a E-R...

Benchmark test for polybase with azure data lake...

Force trusted foreign key SQL Server to allow join culling in view...

Application hosted on AWS to access multiple external DB's...

Dimension for geozones or Lat & Long in data warehouse...

Fact table referencing another fact table?...

Errors in the OLAP storage engine: The attribute key cannot be found when processing...

Azure SQL Data Warehouse Surrogate Keys...

Mini-dimension and DateTime...

Is it possible to upload data to Azure Data Warehouse using an ETL with SSIS?...

Foreign key referential integrity in the fact tables - T-SQL...

Separating Inserts and Updates while loading fact tables...

Cant seem to find the Syntax error...

MongoDB with Hive DW...

Generating star schema in hive...

How to handle denormalization in B.I data model...

Designing a data warehouse for inventory management...

How can I fetch (via GET) all JIRA issues? Do I go to the Search node?...

Valid Warehousing Strategy? Type6?...

SSIS - Cannot insert duplicate key in object 'dbo.FACT_TABLE'...

Is the user table considered a dimension or part of fact...

Surrogate Keys in a Data Warehouse...

Getting a count of users each day in Mondrian MDX...

Please explain about AbInitio recovery file(.rec)?When should we roll back the file?...

Many to many dimension table Library Database...

Alter Table Distribution (Azure Data warehouse)...

DWH from multiple schemas...