Tuesday 11 June 2013

Datawarehousing Question

1.    What is Data warehouse?
2.    What are the types of data warehouses?
3.    What is Data mart?
4.    What is star schema?
5.    What is snow flake schema?
6.    What are ETL Tools?
7.    What are Dimensional table?
8.    What is data Modelling?
9.    What are all the types of dimensions?
10. What is Data Mining?
11. What is Operational Data Store?
12. What is the Difference between OLTP and OLAP?
13. How many types of dimensions are available in Informatica?
14. What is Difference between ER Modeling and Dimensional Modeling?
15. What is fact table and how many types of fact tables?
16. What are the types of OLAP?
17. What is the difference between data mart and data warehouse?
18. What is a difference between OLTP and OLAP?
19. When should you use a star schema and when a snowflake schema?
20. What are the benefits of DWH?

3 comments:

  1. Trade Stocks, Forex, And Bitcoin Anywhere In The World:tradeatf Is The Leading Provider Of Software That Allows You To Trade On Your Own Terms. Whether You Are Operating In The Forex, Stock, Or Cryptocurrency Markets, Use tradeatf Software And Anonymous Digital Wallet To Connect With The Financial World.: tradeatf Is A Currency Trading Company That Allows You To Trade Stocks, Forex, And Cryptocurrency.

    ReplyDelete