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

Fact and Dimension Data-warehouse Datamart

I have two fact tables (purchase and defect ) and both of them are linked to the same dimension. So my question can i combine the two fact to a single fact table (put all the KPI in a single Fact table ). Thank you.
andy
  • 47
  • 5
0
votes
1 answer

Is there a query for Netezza (Toad Data Point) for finding all tables where a specific field name exists

I have the following query which works perfectly when searching for tables that contain a specific field name that I am looking for in an Oracle database however it does not work in Netezza (Data Mart) when using the Toad Data point tool. Can…
ace123
  • 35
  • 1
  • 7
0
votes
1 answer

Do we have to use fact table for reports?

I am working on building a data mart for reporting purpose. I am new to this field and looking for help. I have a fact table and two dimension tables. The fact table has only 3 fields, its primary key and foreign key references to two dimension…
akotian
  • 3,885
  • 1
  • 33
  • 44
0
votes
1 answer

How to find measures in a dataSet

So, I have this dataset here: https://www.kaggle.com/johnolafenwa/us-census-data#adult-training.csv I am new to datawarehouses. I understand what a measure is but I'm not sure what justifies itself as a measure for a fact table? In this dataset what…
Willdomybest18
  • 127
  • 3
  • 12
0
votes
4 answers

Transferring data from a DB2 DB to a greenplum DB

My company has decided to implement a datamart using [Greenplum] and I have the task of figuring out how to go on about it. A ballpark figure of the amount of data to be transferred from the existing [DB2] DB to the Greenplum DB is about 2 TB. I…
bijeshn
  • 1
  • 1
0
votes
1 answer

Get full drilldown of a sparce fact table

I have a transaction fact table and product,time and location as a dimension tables. This fact table is sparse so if no Pizzas sold in January there is no record for Pizza in fact table. When I drill down by product aggregated results for Pizza…
Thamalu Piyadigama
  • 21
  • 2
0
votes
2 answers

Data warehouse or silo data marts

Currently we have 12 different databases and 7 of them are dimensional. We are a non-profit knowledge based org where we have databases based on kind of disease the person has. eg. our databases look like HIV Hepatitis C Meningitis and so…
Jerry
  • 127
  • 1
  • 9
0
votes
1 answer

How to integrate various data marts?

I recently joined a healthcare company and they have separate datamarts for each type of each type of diseases. Lets say I have three different DM's as follows: HIV HepC Respiratory How would I go on to integrate these into one…
Jerry
  • 127
  • 1
  • 9
0
votes
1 answer

warehouse design: tracking the absence of an event

im tracking attendance of courses. There is a user dimension, course dimension and a fact table. I need to track if a user attended a course and if they did not attend a course. I was thinking of storing a record for each user and course in the fact…
wilson_smyth
  • 1,202
  • 1
  • 14
  • 39
0
votes
2 answers

Using a regular database as a data warehouse

Can anyone tell me what the implications are when attempting to use a regular database as a data warehouse? I understand a data warehouse is known for storing data in a more structured manner however what's the implication of using a standard…
Farhan Ahmad
  • 5,148
  • 6
  • 40
  • 69
0
votes
1 answer

Datamart modelling fact table: indicator in columns or lines with one column called indicator

I am modelling a datamart and have multiple measures (indicators ) and dimensions. Is it better when modelling the fact table to make indicators by column or having one column that contains indicators like creating a dimension of indicators ?…
daniel2332
  • 1
0
votes
0 answers

SSIS trying to convert varchar(50) to float from PSA to ODS database

This is a table from our PSA database from a flat file. This is the flat file: We our trying to fill our ODS database with the data from the PSA database. This is the design of the container table from our ODS database: We are using a data…
kjwdamme
  • 289
  • 4
  • 13
0
votes
1 answer

How to implement the following task using SQL in SQL Server

I got this task to work on in which I have to select the care_team_member_name from the DIM_CARE_TEAM_MEMBER table. Conditions are that for a particular care_team_member_Engagement_id, we need to select the member which is active i.e its…
gaurav b
  • 63
  • 5
0
votes
2 answers

Differences between materialized views and data marts in SQL?

I'm trying to understand the difference between the two, and when it would be advisable to use one over the other.
user1834217
  • 39
  • 1
  • 8
0
votes
2 answers

Best way to automatate getting data from Csv files to Datalake

I need to get data from csv files ( daily extraction from différent business Databasses ) to HDFS then move it to Hbase and finaly charging agregation of this data to a datamart (sqlServer ). I would like to know the best way to automate this…
rnside
  • 41
  • 6
1 2 3 4
5
6 7