Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [data-warehouse]

The tag has no usage guidance.

0
votes
1answer
23 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
0answers
17 views

Azure SQL DWH : External File format query is failing

We were using the following query to create the external file format in Azure SQL DWH. And it was working fine. CREATE EXTERNAL FILE FORMAT striim_admin_AzureTarget_FILE_FORMAT WITH (FORMAT_TYPE =...
1
vote
1answer
90 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
votes
1answer
568 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 ...
1
vote
1answer
654 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 ...
1
vote
5answers
5k 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
2answers
8k 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
2answers
833 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 ...