what is difference between
Independent Data Mart Dependent Data Mart
1- 1-
2- 2-
3- 3-
4- 4-
Answer Posted / 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 |
Post New Answer View All Answers
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
How can you communicate with web server (apache or iis) from coldfusion?
What is a linked cube?
Is there any rownum object from which we can do this?
Which are the olap tools available that are supported by oracle?
What are the differences between star and snowflake schema?
Explain what is fact less fact table? Where you have used it in your project?
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.
What is the purpose of cluster analysis in data warehousing?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
What are components of report studio?
Explain what is the metadata extension?
Explain the hierarchies level data warehousing.
Explain differences between star and snowflake schemas?