Questions tagged [data-warehouse]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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?
Robin Rodricks's user avatar
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 ...
user66734's user avatar
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 ...
Cade Roux's user avatar
  • 375
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 ...
Bill Greer's user avatar
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 ...
Sam Elstob's user avatar
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 ...
Henrique Miranda's user avatar
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 ...
William Entriken's user avatar
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 ...
gibbz00's user avatar
  • 103
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 ...
Kenny_I's user avatar
  • 101
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 ...
user557080's user avatar
-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 ...
shreya's user avatar
  • 9