Wednesday, 11 February 2015

microsoft data warehouse interview questions and answers (Page 3)

Below are some important Data Warehouse interview questions which are asked in most MNC company interviews for beginners or professionals.

21. Which technology should be used for interactive data querying across multiple dimensions for a decision making for a DW?


22. What is Virtual Data Warehousing?
A virtual or point-to-point data warehousing strategy means that end-users are allowed to get at operational databases directly using whatever tools are enabled to the "data access network"

23. What is the difference between metadata and data dictionary?
Meta data is nothing but information about data. It contains the information (i.e. data) about the graphs, its related files, abinitio commands, server information etc
i.e. all kinds of information about project related information etc.

24. What is the difference between mapping parameter & mapping variable in data warehousing?
Mapping Parameter defines the constant value and it cannot change the value throughout the session.Mapping Variables defines the value and it can be change throughout the session

25. Explain the advantages of RAID 1, 1/0, and 5. what type of RAID setup would you put your TX logs.
The basic advantage of RAID is to speed up the data reading from permanent storage device (hard disk).
More Questions & Answers :-

No comments:

Post a Comment