Data-warehouse Questions

Where i can download sample database which can be used for data warehouse creation? it should't be sample from microsoft (northwind etc.).

I have three tables and would like to answer the following question in sql: "who has only certifications that do not have

I have a data warehouse containing typical star schemas, and a whole bunch of code which does stuff like this (obviously a lot bigger, but this is

I have bigquery table with record type 'trigger_prop' column and here are two ways using which i am querying but it is resulting out

When trying to read a parquet file with the openrowset and bulk options i encounter the following error:

I am learning the hadoop and came across the hive. and i learnt that hive acts a data warehouse for analytical queries. if data warehouse

I have a table called "accounts" with a composite primary key consisting of 2 columns: account_key and

I want to subtract 2 dates in ms sql server. example: current date last used date '2016-03-30' '2015-02-03'

We need to pull data into our data warehouse. one of the data source is from internal. we have two options: 1. ask the data source team to expose

I have a vertica database that using projections. i read vertica docs but docs generally talk about how to issue;

Is there anyway to get table definitions and data from a sql server bak file to an open source solution?

I am working at rolap on oracle and i have this fact table : sales(market_id,item_id,sale), and i have this query : select

We have a cube that we are populating the data from the source tables. to get the data to reflect we are calling the "analysis services processing

I'm using sakila sample database to create a data warehouse, to get to understand how data warehouses work. here's the structure of the