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

Fact table reconciliation or verify

In a data warehouse project how do I verify that my fact table loaded in a data warehouse DB through SSIS ETL load is correct with my staging table so that later I don't have incorrect reporting?
Ramesh
  • 21
  • 5
2
votes
2 answers

Rapidly Changing Dimension

Recently, I came across the concept of Rapidly Changing Dimensions (Mini dimensions). I understand the part where the fast-changing attributes are removed from the main dimension table and put into a junk dimension (with all possible combinations…
marie20
  • 723
  • 11
  • 30
2
votes
0 answers

Creating datamart with spagobimeta

I am trying to make an olap cube with Spago BI. After creating the tables of dimensions and the table of fact in SpagoBI Meta, I launched the execution for getting the datamart. Unfortunately I got this error : What should I do to resolve…
hbnisea
  • 29
  • 1
  • 6
2
votes
1 answer

Is this a proper idea of BI workflow?

I am new to Business Intelligence. I just got hired by a company in order to complete their websolution, implementing a BI Module. After lot of reading, I think I could get an idea of what a BI Process looks like, you'll find enclose my idea of a BI…
Spredzy
  • 4,982
  • 13
  • 53
  • 69
2
votes
1 answer

Inmon data Marts vs Kimball data marts

Is the only difference between kimball and inmon, the Enterprise layer(EDW). I was googling around and found out that inmon also creates data marts using EDW. so does that mean, both these data marts are similar in structure for a given business…
Vinay Kumar
  • 1,664
  • 2
  • 15
  • 19
2
votes
1 answer

Fact table design guidance for 100s of facts

I'm trying to create a datamart for the healthcare application. The facts in the datamart are basically going to be measurements and findings related to heart, and we have 100s of them. Starting from 1000 and can go to as big as 20000 per exam…
May
  • 100
  • 1
  • 9
2
votes
2 answers

Data warehouse and type 2 SCD and/or daily snapshot fact tables

I am having a trouble deciding which is better for my scenario. the involved dimensions on this scenario are Employee Dimension ╔═════════════╦════════════╦════════╦════════╦═══════════╦══════════╦════════╗ ║ EmployeeKey ║ EmployeeID ║ DeptID ║…
Al DeVidaro
  • 21
  • 1
  • 2
2
votes
1 answer

What is a good web application SQL Server data mart implementation in ElasticSearch?

Coming from a RDBMS background and trying to wrap my head around ElasticSearch data storage patterns... Currently in SQL Server, we have a star schema data mart, RecordData. Rows are organized by user ID, geographic location that pertains to the…
ElHaix
  • 12,846
  • 27
  • 115
  • 203
2
votes
2 answers

Transaction Fact Table approach

I'm working on financial data mart structure. And I'm having some doubts on whats the better approach to do so. The source system database,Dynamics AX 2009, has three tables for customer transaction. One table for open transactions, where the…
vinomalino
  • 55
  • 1
  • 5
2
votes
1 answer

Fact table - select distinct?

in my storage data model I got the following relations: root_tbl -- 1:n -- entry_tbl -- n:1 -- action_tbl There are a few more tables but this covers the basics. Alright, so basically one ID from the root table has several datasets in the entry…
user2428207
  • 825
  • 4
  • 16
  • 29
2
votes
1 answer

I've populated the dimensions - how to populate the fact table?

I've populated 4 dimensions tables these being a time dim, site dim, abandoned dim and worktype dim. I've calculated the measures needed in the end fact table in a staging table but how do I transfer the dimension ID's and the measures into the fact…
Richard C
  • 389
  • 2
  • 5
  • 16
2
votes
1 answer

Data Warehouse: dimensional modeling for dynamic dimensions?

We have a table called user_preferences. They are name value pairs and each user can custom define any number of preferences. What we want in our data warehouse/data mart is to provide reporting on these preferences as if they are dimensions. For…
user1322614
  • 587
  • 1
  • 4
  • 11
2
votes
1 answer

What makes access to OLAP Cubes / Datamarts and similar datastructures, faster than to relational databases?

What makes access to OLAP Cubes/Datamarts and similar datastructures, faster than to relational databases? EDIT A bounty of 200 will be provided asap.
Skippy Fastol
  • 1,745
  • 2
  • 17
  • 32
1
vote
0 answers

Data Mart in Power BI service

I am using Premium per user of Power BI service. When I connect to data source list, there are no Microsoft certified custom connector in the list. Please find the image attached here. How to add our certified custom connector in the list?
Mohanasudharsan K
  • 23
  • 3
1
vote
1 answer

Building a data mart do you use one table for each year? MYSQL

We are storing about 5 to 10 million events each year and now build a datamart that separates operational data out. My question: Would you move the logged events from a given year and store it in a data mart than delete the "event table" and start…
Rob
  • 11
  • 3
1
2
3 4 5 6 7