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

Apache Kylin stuck on 'Convert Cuboid Data to HFile'

I installed the following stack on my lab setup: Hadoop 2.7.1 Hive 1.2.2 HBase 1.7.1 Kylin 3.1.2 I now try to build a cube from the sample dataset provided by Kylin itself, and the process gets stuck at 78.26% "Convert Cuboid Data to HFile". The…
Herry
  • 365
  • 1
  • 14
0
votes
1 answer

T-SQL, Warehouse principle, two datasets combine to one dataset using FIFO

I would like to combine data between two datasets using FIFO. I think the warehouse principle is a good example to explain what I need. BUY table: ID_BUY Date Item Count 39 2022-01-01 00:00 Pencil 1000 41 2022-02-02…
Faltran
  • 25
  • 4
0
votes
0 answers

How to simulate a warehouse without using Rackpick/store or Dynamic Systems?

I would like to simulate a warehouse as part of a process, like using a RackStore, but without linking it to a PalletRack, where in my input they can be agents. I made a quick illustration in relation to my question, maybe it will help to…
Jordan Andres Araya Lopez
  • 1
0
votes
1 answer

How to use the OWB repository assistant using command line

We need to migrate our OWB repository to a new one running on 11.2. This will eventually be converted to ODI but as a 1st step we need to do this migration. I've been following the notes…
rjford11
  • 17
  • 2
0
votes
1 answer

Capturing Insert ,Update and Delete counts from Merge

I use the below T-SQL Merge statement to perform incremental load data from transactional database into Data Warehouse. This Merge statement loads data as a SCD Type 2 and it works well. --Begin handling SCD2 changes INSERT INTO …
Peter Nguy Nguyen
  • 117
  • 3
  • 11
0
votes
2 answers

MySQL - COUNT for rows with the same name

I want to count how many entries with the same name from my table device [device.name] have the value 2 as warehouse [device.warehouse_id]. So for example I have 5 rows, 2 with name = Beam, 2 with name = Spot and 1 with name = Strobe. And now I…
Fabio Whitemountain
  • 3
  • 2
0
votes
1 answer

Override method not being called from warehouse mobile application ax

I have been working on some requirement for advance warehouse mobile application in AX. The requirement was to do something when item is scanned. So in order to perform this I have registeroverridemethod of leave when item text box is build. The…
Zeeshan shaikh
  • 341
  • 1
  • 5
  • 24
0
votes
1 answer

NHS Data Warehouse

I have got coursework, which I do not understand, I tried emailing my tutor but he did not respond and I have been waiting for about 2 months now... I am supposed to create a Star/Snowflake Schema focusing on 2 fact tables. The project must focus on…
G Ivanov
  • 1
  • 2
0
votes
1 answer

Data Warehouse error related to a group by mistake

So I have 2 tables:Clients_Test and Vacations_Test.I need to create a warehouse that has 2 dimensions: d1_month and d2_destination.The main table that shoud contain the fields of these 2 dimensions is the fact table.Also the fact needs to have 2…
Cristi
  • 5
  • 3
0
votes
1 answer

How to create multiple unloading dock using the selectOutput block?

I am working on a warehouse simulation model and I cannot figure out how to increase the number of unloading docks while limiting the docks to one supplier truck. I got it working with 2 unloading docks using the select out with the condition is…
Stefan
  • 1
0
votes
1 answer

How to create orders for picking process at warehouse operations using Anylogic

During the creation of a generalized warehouse model, I ran into a problem when trying to create an order event that can be used by order pickers to retrieve the products from the storages racks. Currently, I am using a source block which creates…
Stefan
  • 1
0
votes
1 answer

How to create specific warehouse order picking strategy in anylogic

I am currently working on a generalized warehouse model containing all processes that take place in warehouse operations. I just started to work with anylogic and I can not figure out how to implement order picking strategies. My current model is…
Stefan
  • 1
0
votes
1 answer

SSIS staging truncate warehouse

Daily we get the data in excel formats we load the data into staging and then go to SSIS package and take excel as connection manager and perform transformations and move the data to warehouse. since we are taking data from excel only then why to…
user14697114
  • 1
  • 1
0
votes
2 answers

TFS Data Warehouse Problem extracting Test Run history - extra rows in FactTestResult table (PointID, ChangeNumber)

I am building a Power BI report to display Test Executions for Azure DevOps (On-Prem). This data is not exposed via OData so I have to use a live connection to the TFS Analysis instance. Due to the live connection in Power BI, I am not able to add…
Johnny Fitz
  • 532
  • 2
  • 8
0
votes
1 answer

Automation of Oracle cloud application (like OTM,CPQ, WHM etc)

Can we automate any of these application using open source (like Test project or selenium, Javascript or cypress) • WMS (Warehouse Management) • TMS (Transportation Management) • Leasing • EPM (Enterprise Performance Management) • CPQ (Configure…
user3595601
  • 1
1 2 3
4
5 6 7