What are data modeling and data mining? Where it will be used?
Why fact table is in a normal form?
What is vldb(very large databases)?
Explain what are data marts?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
List down some of the real time data-warehousing tools?
Explain Association algorithm in Data mining?
Where the cache files stored?
What is surrogate key? Explain with examples.
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Explain what is the difference between power center & power mart?
Explain what are fact, dimension, and measure?
Where the applications and where
Explain clustering algorithm?
What are the advantages of query studio compared to report studio?
