What are snapshots? What are materialized views & where do we use them?
Difference between e-r modeling and dimentional modeling?
What according to you might be the future of data warehousing?
Explain what is full load & incremental or refresh load?
What is the 4 + 1 view model as it relates to system modeling?
Give some difference between oltp and olap.
What is Cognos script editor?
What is the difference between star and snowflake schemas?
What are the stages of datawarehousing?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is surrogate key? Where we use it? Explain with examples.
What is the function of etl when used in data warehousing?
Can you pass sql queries in filter transformation?
What is normalization, first normal form, second normal form, third normal form?
What are the types of partitioning?