Questions tagged [datamart]

A data mart is the access layer of the data warehouse environment that is used to get data out to the users. The data mart is a subset of the data warehouse which is usually oriented to a specific business line or team.

A data mart is the access layer of the data warehouse environment that is used to get data out to the users. The data mart is a subset of the data warehouse that is usually oriented to a specific business line or team. Data marts are small slices of the data warehouse. Whereas data warehouses have an enterprise-wide depth, the information in data marts pertains to a single department. In some deployments, each department or business unit is considered the owner of its data mart including all the hardware, software and data.

This enables each department to use, manipulate and develop their data any way they see fit; without altering information inside other data marts or the data warehouse. In other deployments where conformed dimensions are used, this business unit ownership will not hold true for shared dimensions like customer, product, etc.

References:

99 questions
0
votes
2 answers

Can a Accumulating snapshot table has multiple dates in it?

I am trying to make sense of dimension modeling. While reading a dimension modeling book, I have created a star schema. The fact table is a Accumulating snapshot table and it has multiple date columns which are linked to a date dimension using a…
user18620
  • 120
  • 2
  • 10
0
votes
0 answers

Datamart with data which shouldn't be summarized

how could structure datamart tables with the following problems: Dimension Tables: Person. Time ( hour, minute, day, week). fact Table: group_of_indicators The problem is that if I want to get information from a person in a week, I can't add the…
0
votes
1 answer

unable get output from a shell script running from java program

I am executing a shell script from a java program, in that shell script I am connecting to a datamart server and executing the resmgr command but I am unable to get output of resmgr command, If I run the same command from command line I am able…
0
votes
0 answers

Surrogate key in a datamart

I have 32 dimensions for three fact tables, and i'm currently working on SQL Server 2012 ! As SQL Server's foreign keys are limited to 16 per index, does it mean that i have to use a surrogate key to index my data in the fact tables ?! Or is there…
0
votes
0 answers

Inserting in memory objects (datatable) to database by SSIS Packages

In Sql Server 2008, I need to create a large data mart. I've written .NET Code (C#) for running all SELECT Stored Procs in parallel from code and join the results in datatable in memory. I insert the datatable to database by SqlBulkCopy, but it gets…
Ahmet Altun
  • 3,910
  • 9
  • 39
  • 64
0
votes
1 answer

Better to use a DataMart (BI) or scheduled view to capture rapidly-changing attribute (status)?

Currently we depend on OLTP system to develop reports. Basically, We want to track the sales campaign. So, we need to see the total amount of sales at sales stages of 'Opportunity', 'Proposal', 'Contract Sent' for example. And needless to say that…
mrayess
  • 41
  • 1
  • 6
-1
votes
1 answer

Why isn't my SQL datamart any faster than my raw production database query?

I have a large query that joins numerous tables and runs a bunch of calculations to retrieve YoY Sales Data from 2020 to date. When I run the full query from our production database it takes about 40 seconds to execute and returns about 700,000…
-1
votes
2 answers

Datawarehouse design

I am going to design a Datawarehouse (although its not an easy process). I am wondering through out the ETL process , how the data in the Datawarehouse is going to extract/transform to Data Mart ? Are there any model design within Datawarehouse vs…
mytabi
  • 639
  • 2
  • 12
  • 28
-1
votes
1 answer

rdbms & big data into a datamart?

I have an RDBMS (SQL Server/ Oracle) and a Hadoop database on the other end. Primary-key 'customer' is common in both data stores. A few questions: Is it possible to have a datamart that can pull data from both RDBMS & Big data and produce reports?…
Ady
  • 9
  • 3
1 2 3 4 5 6
7