What is data stream and data adaopter. Is it same are different? Explain?
Explain grouped cross tab?
What are Non-additive facts?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What is analytical or analytic mean?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What are various warehousing tools?
Difference between ODS and Staging
What are aggregate fact tables ? why they are needed? give an example
What is Data purging?
What is dimension modeling?
Which columns go to the fact table and which columns go the dimension table?
How can you set the session management?