Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [data-warehouse]

13 questions
2
votes
2 answers

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
  • 540
  • 2
  • 10
  • 27
1
vote
1 answer

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 table under the…
Bill Greer
  • 275
  • 1
  • 3
  • 13
1
vote
2 answers

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 DATA_DT_ID integer, and I'd really like to be able to…
Cade Roux
  • 375
  • 2
  • 5
  • 18
1
vote
1 answer

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 reading about balanced hardware configuration of data…
Sam Elstob
  • 365
  • 1
  • 3
  • 7
1
vote
5 answers

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 to setup a central mySQL db Linux server and have…
user66734
  • 11
  • 1
  • 3
0
votes
1 answer

Is this application a data vault, data mart or data warehouse?

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 import process: I am collecting data from the source…
William Entriken
  • 543
  • 5
  • 12
0
votes
1 answer

Creating an OLAP data warehouse from an OLTP AWS RDS

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 am not considering redshift as it is more…
gibbz00
  • 103
  • 2
0
votes
0 answers

Approach or tools to transform raw data into usable formats - Data Consolidation, Data Preparation

We are working on data preparation activity for a Datawarehousing project to build an enterprise level data warehouse. As an intermediate layer, we are bringing all the source database information into Hadoop datalake as hive tables. In our use…
Sakthivel
  • 1
0
votes
0 answers

Reasons for having several data marts instead of only one central data warehouse. What are the tradeoffs here?

What are the reasons for having several data marts instead of only one central data warehouse. What are the tradeoffs here? According to my understanding, one of the reasons should be the following: If one of the many data marts loses its…
Test
  • 101
0
votes
1 answer

Need help deciding best MariaDB storage engine for our use case and server hardware limitations

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 we think that we could move some historical data…
Henrique Miranda
  • 103
  • 4
0
votes
1 answer

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 last month to analyze costs? B) How to do migration…
Kenny_I
  • 101
0
votes
1 answer

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 cross data warehouse communication is possible in Azure…
user557080
  • 1
  • 1
-1
votes
1 answer

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 and convert the schema from Oracle database but,…
shreya
  • 9
  • 1