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

Where could I get the number of existing unit tests

I like to get the number of the unit tests in each build which were running last year. So that I could see if the developers write some new tests. For that, I get a view of the TFS warehouse database and find the view TestResultView which exactly…
user2523397
  • 1
  • 1
0
votes
2 answers

Issue with TFS 2017 Data Warehouse

We have migrated our Team Foundation Server from 2013 to 2017 recently. In previous version there was no Data Warehouse or reporting configured. After moving to TFS 2017, we configured Data Warehouse and Reporting services which went fine without…
A_d_v
  • 3
  • 3
0
votes
1 answer

TSP in warehouse (multiple localization of one item)

I wanna write my masters thesis about computer optimization of warehouse processes because I work as a programmer in a shipping company and I thought it might be useful. Can anybody tell me if it is possible to adjust a TSP problem to create a path…
Elterian
  • 11
  • 4
0
votes
1 answer

Design of fact table

My question is about modeling of fact_table in data warehouse. for example , we have users that subscribe to different subjects and we want to track when they started subscription. each user belongs to specific department. and users can change their…
sia
  • 537
  • 1
  • 6
  • 22
0
votes
2 answers

SQL server - realtime and historical dashboard reading form tables

I have APPS Service hosted on azure using Azure SQL Database with around 15 tables: - assistances - users - eventLogs etc. Currently I have around 150k records, and on daily based my DB is receiving around 2000 new assistances with new users…
dmoczydlowski
  • 15
  • 1
  • 1
  • 5
0
votes
1 answer

TFS2015 modified Scrum Template Tfs_Warehouse DimWorkItem System_WorkItemType always null

We use a modified Template based on the Scrum template. Basically there are some new fields introduced we are need for our deployment process. After some time we looked into reporting and take a look in the Tfs_Warehouse database and notices that…
Erich Bauer
  • 111
  • 1
  • 7
0
votes
1 answer

Oracle error: VLD 0350

I am trying to deploy a dimension in Oracle Warehouse Builder, and when I do, I get error message VLD-0350: In a hierarchy PARENT_LEVEL, level relationship binding between parent level PARENT_LEVEL and child level CHILD_LEVEL does not exist. Within…
Šišmiš Miš
  • 1
  • 3
0
votes
1 answer

Make Barcode functionality for Odoo 10 Community Version

I want to make a barcode in Inventory picking screen since it's not supported in Odoo 10 Community version. What do I have to search for, and learn?. I saw the barcode module, what the purpose of it and how it can be useful in my case? In addition I…
Mahmoud Al Shaikh
  • 11
  • 4
0
votes
1 answer

CS-Cart: integrating Fishbowl

I am developing a cs-cart based website and my client wants to integrate Fishbowl into his website. I have searched an add-on for it, but there is no one for me. I have experience developed a simple add-on and, now I am going to build one add-on to…
Adams Xiao
  • 53
  • 7
0
votes
1 answer

Populating fact table

I've a data warehouse for sales, it has 3 dimensions [product,time,store] and a fact table [sales_fact]. Primary key of 'sales_fact' table is made up of all primary keys of dimensions table, dimension tables are all filled up manually now I want to…
vatob
  • 53
  • 1
  • 10
0
votes
0 answers

How to load a data warehouse dimension from a slowly changing entity?

I'm creating some dimensions from a source system (OLTP) which already tracks changes to rows using the Kimball type 2 method. I read in his latest book he calls these "Slowly Changing Entities" but he doesn't explain how to load them into a data…
J. Mclane
  • 1
0
votes
1 answer

Data warehouse, SSAS

I have been given population data like this; Year Region Population ---------------------------------- 2012 District1 1000 2012 District2 1500 2012 District3 2000 Now I have to make a cube where a user can…
hiren soni
  • 174
  • 2
  • 2
  • 17
0
votes
1 answer

TFS DB query to get merged changesets from one branch to another

I would like to make a report that will show what changesets were promoted from one branch to another one. I've got all needed information about changesets in my query, but i cannot find a reference between changeset from the MAIN branch and…
bbranco
  • 5
  • 2
0
votes
0 answers

found an error while proceeding to delivery order in odoo v9

In odoo v9 when proceeding to delivery order of a respected product , giving me an error so , what can I do to proceed my flow further I have installed db without demo data give me steps
sakib keriwala
  • 129
  • 3
  • 14
0
votes
1 answer

Magento Checkout Progress is empty

I asked everywhere. I wrote a mail to the developers, who selled the extension. (Innoexts Warehouse). But no one could give me an answer! I have installed this extension. First it worked great. Then i updated the webshop to 1.9.2.1. and the progress…
Horatio Mnml
  • 19
  • 3
1 2 3 4 5
6
7