What is difference between e-r modeling and dimensional modeling?
What are the different types of segments?
What are aggregate transformation?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
Is there any difference in testing database and data ware housing?
What is type 2 version dimension?
How to handle multi value dimensions?
what is a hot file, why we need in datawarehousing, where we used in general
Explain what are the advantages of query studio compared to report studio?
Advantages of de normalized data?
Explain functional dependency?
how much memory space occupied real time project (roughly)?
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?