Stack Overflow
Stack Overflow

Questions tagged [warehouse]

A data warehouse is a system used for reporting and data analysis, which integrates data from one or more disparate sources into a central repository of data used for trending and reporting.

A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.

In addition to a relational database, a data warehouse environment includes an extraction, transportation, transformation, and loading (ETL) solution, an online analytical processing (OLAP) engine, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users.

http://en.wikipedia.org/wiki/Data_warehouse http://docs.oracle.com/cd/B10501_01/server.920/a96520/concept.htm

100 questions
3
votes
1 answer

Figuring out dimensions for a DW

I have the following database schema from which I want to create DW with the needed dimensions for the following KPIs: Number of personel by training (formations) HR turnover Absences by category What I'm trying to figure out is which dimensions…
Baha
  • 56
  • 7
3
votes
1 answer

How can I use a column named _id from a dashDB table?

I have a database in Cloudant where the document ID is _id. After replicating this data from Cloudant to dashDB I have 2 separate tables that I want to join using this _id column. In Run SQL I tried the below, but this would not run. What am I…
Margriet
  • 35
  • 6
2
votes
0 answers

how are Updates and Deletes handled in both Data Warehouses and Data Lakes?

I'm trying to understand how Update and Delete functions are performed in Data Warehouses, Lakes and Lakehouses. Databricks argues that they can perform upserts easily, which I would understand as adding CRUD capabilities. I've read elsewhere that…
Gonzalo Etse
  • 123
  • 1
  • 7
2
votes
1 answer

Snowflake change tracking metadata for a table

If I enable the change tracking metadata for a table, will that have an additional cost? ALTER TABLE … CHANGE_TRACKING = TRUE; And with this enablement DML operations will slow down?
jsrathnayake
  • 139
  • 10
2
votes
1 answer

Privileges lost after dropping objects in Oracle

I have a data warehouse that consists of a specific schema for reporting. Anyone who is granted access to it will be given privileges to objects in that schema. However, whenever I drop objects, those privileges are lost. What are the best…
samg
  • 311
  • 1
  • 8
  • 21
2
votes
0 answers

Odoo warehouse Scan the bar code of the package to record the number of items it contains

I want to know if the functionality that I imagine exists with Odoo. I have a product, "Pen" which had the barcode : 111122223333. I have first type of packaging : Package A 50 pens, who had the barcode 111122223350. Second type of packaging : Box…
mohamed abdelbassat Salhi
  • 39
  • 5
2
votes
0 answers

add data collection component sql server 2008

I have been searching for hours, and I can't find a way to add data collection component in object explorer , ps: I'm using sql server 2008 r2
user3676872
  • 204
  • 1
  • 12
1
vote
0 answers

Snowflake - No active warehouse selected

i am just a beginner on snowflake. I am using trial version. I am trying run basic command of select * and Db i am taking is Snowflake sample data. I am getting this error = 000606 (57P03): No active warehouse selected in the current session. Select…
Aarushi Singh
  • 11
  • 1
1
vote
1 answer

How to model many to many relationships in data warehouse dimmensions

I'm starting to learn about data warehouses and have run across a scenario I can't wrap my head around. I was attempting to sketch out a data warehouse that would track monthly sales for different stores. If the source OLTP database for stores has a…
Ben M
  • 11
  • 2
1
vote
1 answer

Accessing special storage in storage system Anylogic

I need to access a specific storage within a storage system (which is basically a list like this storageSystem= {storage1, storage2, storage3} in Anylogic. I tried this, but it does not work: storageSystem Storages[0].getSlot(0, Bay1, 0); Thanks in…
sljb12
  • 11
  • 1
1
vote
0 answers

spark sql unable to find the database and table which it earlier wrote to

There is a spark component creating a sql table out of transformed data. It successfully saves the data into spark-warehouse under the .db folder. The component also tries to read from existing table in order to not blindly overwrite.…
Ria Arora
  • 11
  • 2
1
vote
0 answers

sql query issue: warehouse aging inventory when negative entries

I found a warehouse aging inventory example online (see modified code below). Everything works fine if the entry type for purchase (0) is positive and for sales (1) is negative. But if the values are inverse (because of cancellation) then the…
pawe84
  • 21
  • 2
1
vote
2 answers

The principle of the effect of snowflake warehouse size

I'm experimenting with snowflake. I would like to know how it works as an architecture. I'm using three types of queries A, B, C with different numbers of bytes being scanned. The size of Bytes Scanned is reading Total Statistics in Profile…
SNWsnow
  • 35
  • 4
1
vote
0 answers

How do you fix TFS GUID names in TFS Analysis db after upgrade/migration?

I upgraded and migrated TFS 2017 to TFS 2018 by moving Tfs_Configuration and Tfs_DefaultCollection only to a new DB server. I reconfigured Tfs_Configuration and Tfs_DefaultCollection in a new environment and rebuilt Tfs_Warehouse and Tfs_Analysis…
C1TonyB
  • 133
  • 1
  • 6
1
vote
1 answer

What should be Snowflake Warehouse Sizing

We decide to re-architect our product storage with snowflake to store our timeseries data. Currently we have 10 TB timeseries data(which increase daily) and 6 jobs which triggers after every 15 min interval and utilize almost 40GB/day data for…
Vijay
  • 11
  • 1
1
2 3 4 5 6 7