Questions tagged [data-warehouse]
The data-warehouse tag has no usage guidance.
11
questions
2
votes
2
answers
12k
views
Data center vs Data warehouse
I've heard both of these terms used frequently. What is the difference between a Data center vs. a Data warehouse? Are these terms interchangeable?
1
vote
5
answers
8k
views
minimum required bandwidth for remote database server
I want to build a small warehousing application for my company. We have a central warehouse which distributes to 8 sales points across the country. They insist on an in-house solution. I am thinking ...
1
vote
2
answers
840
views
Easy Table Partitioning in SQL Server 2005 for Fact Tables?
I've been reading the article at http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx in preparation for implementing some partitioning.
I have several tables I want to partition on a ...
1
vote
1
answer
315
views
How does Original Estimate work in Team Foundation Server
If I pull up a task for a particular project there is a field called original estimate. The only place I can find the original estimate is in the Tfs_Warehouse database in the FactWorkItemHistory ...
1
vote
1
answer
712
views
Oracle data warehouse on SAN. Is the throughput of > 400MB/s possible?
We are developing and deploying a data warehouse based on Oracle 11g EE with partitioning on RHEL5 64bit for a client.
The total storage required would be around 4TB of usable space.
I have been ...
0
votes
1
answer
246
views
Need help deciding best MariaDB storage engine for our use case and server hardware limitations [closed]
I work for a small company and we are in need of a data warehouse.
Our production database have around 50Gb of data (grows ~10GB/year, currently), our server is running a little over it's capacity and ...
0
votes
1
answer
41
views
Is this application a data vault, data mart or data warehouse? [closed]
I am importing information from various source systems and putting them into local databases for reporting. For example, one of the sources is Google Analytics.
Here are some attributes of this ...
0
votes
1
answer
361
views
Creating an OLAP data warehouse from an OLTP AWS RDS [closed]
I have an OLTP AWS RDS(in postgresql and very normalized) that powers an application. I am trying to create a separate data warehouse(OLAP use case) also in AWS RDS(postgresql) using a star shchema. I ...
0
votes
1
answer
368
views
How to migrate Dedicated SQL Pool (DW) to Serveless Synapse?
I have Azure Datawarehouse which has fixed pricing tier DW100. Usage is small and assuming that Serverless can be cheaper.
A) How do get information how much data processing have been occurring in ...
0
votes
1
answer
26
views
Cross reference between azure sql data ware houses
In one sql server instance, I have below 2 data warehouses,
sqlwarehouse1
sqlwarehouse2
And in sqlwarehouse2, I have the table "dbo.test". How can I refer this table from sqlwarehouse1? Is this ...
-1
votes
1
answer
769
views
Migration between Oracle and Azure SQL Data warehouse using SSMA
I am facing the below error while syncing table from Oracle to an Azure SQL data warehouse using SSMA tool (a tool used to migrate data from Oracle to Azure SQL). I am able to connect to the database ...