A data warehouse (DW) is a database specifically structured/designed to aid in querying, analyzing and reporting (generating reports out of) of current and historical data.
Jumping from article to article, I can see everywhere the expression "bulk loading". What does it really (technically) mean? What …
database terminology data-warehouse bulk-loadWhere I can download sample database which can be used for data warehouse creation? It should't be sample from Microsoft (…
database data-warehouseI'm new to data warehousing. First, I want to precise than my copy of The Data Warehouse Toolkit is on …
data-warehouse fact-tableAre staging tables used only in Data warehouse project or in any SSIS Project? I would like to know what …
ssis etl data-warehouse staging-tableI am in process of designing a Data Warehouse Architecture. While exploring various options to Extract data from Production and …
database-design data-warehouse olapI'm building a data warehouse. Each fact has it's timestamp. I need to create reports by day, month, quarter but …
data-warehouse infobrightI am writing a query to fetch records from a Oracle warehouse. Its a simple Select Query with joins on …
sql oracle data-warehouse analytic-functionsCurrently we are using Avro data format in production. Out of several good points using Avro, we know that it …
apache-spark hadoop data-warehouse avro parquetI am currently working in a few projects with MongoDB and Apache Cassandra respectively. I am also using Solr a …
mongodb cassandra data-warehouse vertica greenplumWhat are the relations between NoSql and Data-Warehouse technologies/theories? What concepts they share? What are the basic differences between …
nosql data-warehouse