what is difference between Independent Data Mart Dependent Data Mart 1-

what is difference between

Independent Data Mart Dependent Data Mart
1- 1-
2- 2-
3- 3-
4- 4-

Question Posted / king10

4 Answers
21875 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is difference between Independent Data Mart Dependent Data Mart 1- 1..

Answer / ranjan

Independent datamart:it does not get data from datawrehouse
Dependent data mart: It gets data from datawarehouse.

Is This Answer Correct ?

25 Yes

6 No

what is difference between Independent Data Mart Dependent Data Mart 1- 1..

Answer / rams

Independent Data Mart Dependent Data Mart
1) it won't have 1) it will share the common dimension
shared Dimension
2) perfect Data mart 2) it's a Enterprise DW

Is This Answer Correct ?

13 Yes

4 No

what is difference between Independent Data Mart Dependent Data Mart 1- 1..

Answer / nav

independent data mart derives data from external sources whereas dependent derives from central warehouse

Is This Answer Correct ?

5 Yes

0 No

what is difference between Independent Data Mart Dependent Data Mart 1- 1..

Answer / mohammed

any other difference

Is This Answer Correct ?

6 Yes

8 No

Post New Answer

More Data Warehouse General Interview Questions

What are the different ways to represent the loading of dimension tables?

0 Answers

Explain what are the various transformation available?

0 Answers

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

0 Answers

How do you create surrogate key using ab initio?

0 Answers

What is a fact table?

1 Answers

5.Explain ODS ?

3 Answers HCL,

Explain what is the difference between power center & power mart?

0 Answers

What is DTS ?

1 Answers

Is there any difference in testing database and data ware housing?