Search code examples
Generic vs Conformed dimensions...

databasedata-warehousedimensional-modelingstar-schema

Read More
OLTP-STAGGING-DW-DUPLICATES...

data-warehousestagingstar-schemaoltp

Read More
How do I get 1 record as result including a left join including a loop?...

sql-serverloopsleft-joindata-warehouse

Read More
Best practices for primary keys in partitioned fact tables in a data warehouse with PostgreSQL...

postgresqldatabase-designpartitioningdata-warehouse

Read More
Calendar Dimension in Datawarehouse Modeling...

data-warehousekimball

Read More
SSIS Surrogate Key incrementation...

ssisdata-warehousestar-schema

Read More
Azure data sync from Azure Db to Azure DWH...

azureazure-sql-databasedata-warehousedatabase-replicationazure-data-sync

Read More
Snowflake how to call External Function in Snowpark...

pythonsqlsnowflake-cloud-data-platformdata-warehouse

Read More
SCD TYPE 2 Implementation...

sqlsql-serverdata-warehousescdsql-data-warehouse

Read More
Star-Schema Design...

databasedesign-patternsdata-warehousestar-schemadimensional-modeling

Read More
Data Modeling with a Time Dimension...

data-modelingdata-warehousebusiness-intelligence

Read More
Could azure data warehouse be inside an Azure SQL Elastic Pool?...

azureazure-sql-databasedata-warehouseazure-elasticpool

Read More
What is the best way to transfer data from SAP to SQL Server?...

ssisetldata-warehousesap-erpsap-dotnet-connector

Read More
Null Foreign Keys in Fact Table...

databasedatabase-designdata-modelingdata-warehouse

Read More
Time and date dimension in data warehouse...

data-warehouseinfobright

Read More
Can I store textual fields in fact table of Datawarehouse?...

databasedatabase-designdata-modelingdata-warehousefact-table

Read More
What is the best approach to move data between regions in Snowflake for the Federated Datawarehouse?...

amazon-web-servicesdata-warehousesnowflake-cloud-data-platformfederated

Read More
Month over Month querying in multiple dimension tables...

sqlazure-sql-databasedata-warehouse

Read More
Fact Table and Grain - Repeating Measures?...

data-warehousedimensional-modelingfact-table

Read More
Manage Big Query table from Google Sheet...

sqlgoogle-bigqueryairflowdata-warehouse

Read More
Bigquery : Frequent Updates to a record...

google-cloud-platformapache-kafkagoogle-bigquerydata-warehouse

Read More
Differences between Data Vault and Dimensional modeling?...

database-designdata-modelingdata-warehousedata-vault

Read More
What is a data warehouse?...

databasedata-structuresdata-warehouse

Read More
PostgreSQL to Data-Warehouse: Best approach for near-real-time ETL / extraction of data...

postgresqldata-warehouseetlnear-real-timedata-extraction

Read More
Nifi handling failures and restarts without losing incoming data...

apache-nifidata-warehouse

Read More
Using normalised table schema of RDS directly in Redshift...

amazon-web-servicesamazon-redshiftdata-warehouse

Read More
Snowflake insert overwrite behaviour...

sqlsnowflake-cloud-data-platformdata-warehouse

Read More
Pub/Sub: How to retrieve messages sent to a dead-letter-topic and store them into a BigQuery table?...

google-bigquerygoogle-cloud-pubsubdata-warehousedead-letter

Read More
Aggregate functions for daily totals using records with start and end dates...

sqlgoogle-bigquerydata-warehouse

Read More
ETL using Python...

pythondata-warehouseetl

Read More
BackNext