Explain meta data?
What are the different types of join operations?
How to generate the cubes in framework manager?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What is the very basic difference between data warehouse and operational databases?
What is data type of the surrogate key?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What are universe requirements?
What are data validation strategies for data mart validation after loading process?
What is the main difference between star and snowflake star schema? Which one is better and why?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What are aggregate tables and aggregate fact tables?
Explain me what is vldb?
What is difference macros and prompts?
What is defined as partial backup?
