How to create different types of templates?
what role views play in dimensional modeling?
how can one connect two fact tables ? is it possible ? how?
What are algorithms provided by Microsoft in SQL Server?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is Snow Flake Schema design in database?
what are different ways of loading data to data warehouse using oracle?
What are the various methods of getting incremental records or delta records from the source systems?
Explain piconet?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Explain the difference between oltp and olap?
Explain what are necessary tasks to install reportnet software?
How can you implement many relations in star schema model?