what is difference between
Independent Data Mart Dependent Data Mart
1- 1-
2- 2-
3- 3-
4- 4-
Answer Posted / 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 |
Post New Answer View All Answers
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?
Explain what is a view as it relates to system modeling?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are the other names given to data warehousing?
what type of raid setup would you put your tx logs?
What is a hash cluster?
What is the difference between dependent data warehouse and independent data warehouse?
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.
Explain what are the methodologies of data warehousing?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is cfapplication tag?
How can we determine what records to extract?
How can you set the session management?
What is the difference between static cache and dynamic cache?