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
0
votes
1 answer

How does warehouse size change automatically in Snowflake?

I have a small warehouse in SnowFlake, with minimum clusters = 1, maximum clusters = 5 and scaling policy set to standard. However, when I was viewing the query history profile, I saw that for some of the queries, size column was set to large, but…
ghost
  • 1,107
  • 3
  • 12
  • 31
0
votes
1 answer

Anylogic retrieve occupied gate location

There is Distribution Center model on the Cloud that a little bit hard to understand for a novice user. I need to understand how to retrieve gate location where the Truck is parked. So that forklift knows where the pallets are to pickup. Anylogic…
jazzman
  • 1
0
votes
1 answer

General question about Power BI and SQL Server

We are in the process of creating a dashboard with Power BI. We have two licenses of Power BI pro that we are using the create a dashboard with a SQL Server backend. Can people share with me how they distributed the Power BI reports they developed…
John Connolly
  • 39
  • 9
0
votes
1 answer

Where are the Description and Discussion fields in TFS stored in the SQL database

I've been looking in the TFS_Default Collection and TFS_Warehouse database's but haven't had any luck. Any advice or tips would be greatly appreciated.
Daniel Gibson
  • 11
0
votes
3 answers

ER modelling tool for Snowflake

From snowflake documentation it seems that there is an ER application that will allow connecting to the dwh to create diagrams - https://www.snowflake.com/blog/support-multiple-data-modeling-approaches-with-snowflake/. Does anyone know what tool is…
marcin2x4
  • 1,321
  • 2
  • 18
  • 44
0
votes
2 answers

in Snowflake, Does resize an existing warehouse helps in improving the performance of a running query?

in Snowflake, Does resize of an existing warehouse helps in improving the performance of a running query ?
anuja25
  • 1
0
votes
1 answer

How can I track moving items in real-time in Power BI?

I saw this Warehouse Dashboard on Youtube (Login as Vendor without any username or password) https://pbiewarehousedemo.azurewebsites.net/warehouse-summary and I was wondering how they created this Warehouse Map with the moving items. It seems to be…
Phill
  • 3
  • 1
0
votes
1 answer

V2/V3 of Db2 Warehouse Rest API

I am currently trying to use the Rest API with a standalone docker image of Db2 Warehouse developer edition. I have downloaded the docker image from the IBM docker hub "https://hub.docker.com/_/ibm-db2-warehouse-dev?tab=resources" After having…
Steph
  • 47
  • 1
  • 8
0
votes
0 answers

Is there a resource that moves diagonal?

I am modeling an automated storage, retrieval system. I need a reource that can move horizontally and vertically at the same time (diagonally) to store and retrieve agents in the Rack. I found this model in AnyLogic cloud and I am interested to…
saba tavangar
  • 13
  • 3
0
votes
1 answer

Azure Data Warehouse to CosmosDB sync with data factory pipeline

I would like to set up a pipeline to sync data from Data Warehouse to no sql CosmosDB. Copy tool works fine for one to one table relations but for one to many obviously, I will have duplicates of objects in my NoSQL DB. What is the best way to solve…
Viacheslav Shelestovskiy
  • 9
  • 2
0
votes
1 answer

dbload vs insert in db2wh, which is better to use for loading data and what are the differences between these two

In db2wh, One of our tasks is to look for candidate alternatives for INSERT FROM master SELECT * FROM staging and dbload may be the one. Comparing the elapsed time of INSERT and dbload from a same local CSV file, dbload is a little bit faster than…
Kapish Kumar
  • 143
  • 2
  • 15
0
votes
0 answers

PRESTASHOP cannot access carier, stock and warehouse

I cannot access carrier, stock and warehouse from BO, it threws this kind of error and I don't understand what this error is all about. Kindly please guide me because I'm quite new with prestashop. Please refer to the image link below to see the…
maiy seira
  • 1
  • 2
0
votes
1 answer

Warehouse Management System overview program

Good morning SO people, First a bit of general information: I work in a warehouse with goods we manage with a WMS system which I operate. This program is on a VPN thats hosted in Switserland while i'm in Holland. I get also orders in this program…
Alexander
  • 11
0
votes
0 answers

Oracle - Design of data warehouse tables

I understand that it makes sense to store dimension tables as index organized tables and fact tables using bitmap indexes for the dimension columns, however what should be done in the scenario where a fact table is used within another fact table?…
Superdooperhero
  • 7,584
  • 19
  • 83
  • 138
0
votes
1 answer

closest max date to target date between two columns, get associated item with result, all constrained by common location

The oracle table that I'm trying to query has multiple date columns that give timestamps for warehouse activity, both with an item and location associated with them. I'm trying to find the item that was in a location at a certain date. Activity…
Warehouse-Data-Monkey
  • 1
  • 1
1 2 3 4
5
6 7