Questions tagged as 'data-warehouse'

2
answers

Surrogate Key and Natural Key

I am studying about data warehouse , but I was confused about the concepts of SK and NK. As I understand in a DW, a natural key would be a foregin key column in the dimension table of the column that is PK referring to the same table in...
asked by 18.02.2018 / 18:30
1
answer

Why does bitmap indexing work well for low cardinality domains?

I have just read Chapter 29 of the Data Warehousing and OLAP overview On page 725, the author talks about indexing techniques to support high-performance access, this technique is called bitmap . That is how the question arose and consequ...
asked by 09.11.2017 / 15:40
1
answer

Bottom Up Approach in Data Warehouse

Within the Data Warehouse (DW) context, I'd like to know:    Why it is correct to say that this approach (Bottom Up) does not guarantee standardization of metadata, and can create data inconsistencies between Data Marts (DM). I found an...
asked by 12.11.2017 / 23:12
0
answers

What is the difference between a data warehouse and a data lake?

Given the concepts of data warehouse and data lake , what notable differences can we cite between them?     
asked by 04.12.2018 / 23:42
1
answer

Roll-Up or Drill-Down, Which has the largest Data Warehouse Detail?

Context Studying data warehouse (DW) I came across content regarding the types of OLAP servers and the types of operations that can be done, within that context I was confused about the concept of detailing two operations, they are called Ro...
asked by 17.11.2017 / 16:50
1
answer

Data Warehouse is Transaction-Oriented?

Problem Context Reading the Data Warehouse issue, I drew some distinct conclusions about what the textbook states.    Notice what the author explains in relation to transaction-oriented DW:       IunderstandthattheauthorstatesthatDWare...
asked by 09.11.2017 / 17:47
1
answer

Database queries

What is the Staging Area for? Can I search Data from other systems (different banks)? What is a Data Mart? Is it linked to the organization's business sectors or processes?     
asked by 05.04.2017 / 00:47
1
answer

Pentaho Data Integration repository does not appear in POI

Good evening. I have a constant problem with the POI. Sometimes when I open spoon.bat it does not load the repository or even enable the option to connect to a repository. I have already researched in several forums and so far the past soluti...
asked by 06.11.2018 / 21:51