Stack Overflow
Stack Overflow

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
1 answer

BigQuery slower than SQL Server

I am comparing query execution times in my data marts between SQL Server 2016 (Star Schema and using column based clustered index) and BigQuery (one single table)..I have around 20 million entries. Here is my query - I need month wise Sum of Oil,…
Abhay
  • 928
  • 1
  • 10
  • 28
0
votes
1 answer

Force trusted foreign key SQL Server to allow join culling in view

I'm trying to create a star schema view of fact to it's dimension. eg. if the view is Select _fact.A, _Dim.B from _fact inner join _dim on _Fact.dim_sk = _dim.Dim_sk and I query Select _Fact.A from _view It will ignore the join in…
Anthony Liu
  • 343
  • 1
  • 12
0
votes
1 answer

How to handle dimensions with similar attributes?

I have the following entities in my data mart: Location: Contains information like Country, City, etc. Users: Contains information about a user this includes their address, which includes Country and City Both these dimensions contain attributes…
Amous
  • 534
  • 5
  • 18
0
votes
1 answer

MDX Scope returning NULL #VALUE

I have been on this issue for the past 2 weeks and am getting bored of MDX and my work. I have a scope script to override the figure coming from the source table for the following lines. 1. Pool Charge (2075) 2. Pool Compensation (2076) SCOPE…
Abacus
  • 70
  • 5
0
votes
1 answer

How to order ETL tasks in Sql Server Data Tools (Integration Services)?

I'm a newbie in ETL processing. I am trying to populate a data mart through ETL and have hit a bump. I have 4 ETL tasks(Each task filling a particular table in the Mart) and the problem is that I need to perform them in a particular order so as to…
Farhan Haider
  • 1,244
  • 1
  • 13
  • 22
0
votes
1 answer

Loading time dimension table t-sql

I am trying to (synthetically) populate an empty time dimension table in a star modeled data mart, after which it should look like this: I am using the following T-SQL code for this: /* STEP 3 Populate DIM_TIJD table with date and its derrived…
R. Neven
  • 31
  • 2
  • 7
0
votes
1 answer

are there any downsides to a full load-strategy for datamarts...?

... apart from the performance impact? In our situation, the data volumes will be overseeable, the complexity may not. Background: I have experienced a project where the datamarts were fully loaded each day. This simplified the ETL because no delta…
Rusty75
  • 477
  • 7
  • 19
0
votes
2 answers

How to solve if there are two different granularity in data mart ?

We are creating data mart from data source that we are given. I have created following tables in data mart. FactPopulation (Fact table which has population data per year) FactMeeting count (Fact table which has event info occur almost everyday…
Justin
  • 393
  • 1
  • 7
  • 21
0
votes
0 answers

1 billion rows DW to DM

I have a design/performance question. I have this next table. CREATE TABLE [dbo].[DW_Visits_2016]( [VisitId] [int] NOT NULL, [UserId] [int] NOT NULL, [VisitReferrer] [varchar](512) NULL, [VisitFirstRequest] [varchar](255) NOT NULL, …
Chicago1988
  • 970
  • 3
  • 14
  • 35
0
votes
2 answers

Oracle - Delete One Row in Dimension Table is Slow

I have a datamart with 5 dimension table and a fact table. I'm trying to clean a dimension table that has few rows (4000 rows). But, the fact table have millions rows (25GB)(Indexes and partitions). When I try to delete a row in the table…
JohnPortella
  • 1,791
  • 5
  • 21
  • 30
0
votes
2 answers

Suggestions for creating an in-house marketing campaign database in a Microsoft environment?

I'd like to create an in-house solution to store marketing segment, list, campaign, and communication data. Right now nothing is centralized/standardized. Data is located on a variety of SQL servers, Access databases, and Excel spreadsheets. It's…
MattB
  • 714
  • 1
  • 8
  • 18
0
votes
1 answer

Export table data from a particular data mart?

To obtain a list of all tables from all data marts in a data warehouse using Sybase, we use select * from sysobjects where type = 'U' However, I want to grab and export all tables from a particular data mart ("DM"). I'm relatively new to Sybase, so…
blacksite
  • 12,086
  • 10
  • 64
  • 109
0
votes
1 answer

Difficulty modeling Star schema

First of all, I'm sorry about the title... As soon as someone answer it and I understand what was my actual problem, I'll put a better one. I am creating a fact table which will measure the amount of reasources related to schools: Amount of…
Leonardo Sibela
  • 1,613
  • 1
  • 18
  • 39
0
votes
1 answer

string as primary key in star schema

We are creating a Data Mart consisting of around 8 Star Schemas, each representing a business event, process or reporting set of data. We have an equal mix of Transaction, Snapshot and Accumulating Snapshot schemas. The value we are intending to use…
john
  • 145
  • 1
  • 4
0
votes
1 answer

Data Mart star schema development solution

i have to translate a DB into a DM, but i have some doubt about, this is the DB schema: https://i.stack.imgur.com/PHha1.png This is a simple DB to store authors, books and various othe things (foreign keys of author table are wrongs and the table…
Neo87
  • 63
  • 1
  • 11
1 2 3 4 5
6
7