Category Archives: Data Warehousing Interview Questions

Explain the advantages of RAID 1, 1/0, and 5. what type of RAID setup would you put your TX logs. | Data Warehousing Questions

The basic advantage of RAID is to speed up the data reading from permanent storage device (hard disk).

Posted in Data Warehousing Interview Questions | Leave a comment

What is the difference between mapping parameter & mapping variable in data warehousing? | Data Warehousing Questions

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.

Posted in Data Warehousing Interview Questions | Leave a comment

What is the difference between metadata and data dictionary? | Data Warehousing Questions

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.

Posted in Data Warehousing Interview Questions | Leave a comment

What is Virtual Data Warehousing? | Data Warehousing Questions

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”.

Posted in Data Warehousing Interview Questions | Leave a comment

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a DW? | Data Warehousing Questions

MOLAP

Posted in Data Warehousing Interview Questions | Leave a comment

What is the difference between dependent data warehouse and independent data warehouse? | Data Warehousing Questions

Dependent departments are those, which depend on a data ware to for their data.Independent department are those, which get their data directly from the operational data sources in the organization.

Posted in Data Warehousing Interview Questions | Leave a comment

What is the main difference between star and snowflake star schema? Which one is better and why? | Data Warehousing Questions

If u have one to may relation ship in the data then only we choose snowflake schema, as per the performance-wise every-one go for the Star schema. Moreover, if the ETL is concerned with reporting means choose for snowflake because … Continue reading

Posted in Data Warehousing Interview Questions | Leave a comment

What is critical column? | Data Warehousing Questions

Let us take one ex: Suppose ‘XYZ’ is customer in Bangalore, he was residing in the city from the last 5 years, in the period of 5 years he has made purchases worth of 3 lacs. Now, he moved to … Continue reading

Posted in Data Warehousing Interview Questions | Leave a comment

How can you implement many relations in star schema model? | Data Warehousing Questions

Many-many relations can be implemented by using snowflake schema .With a max of n dimensions.

Posted in Data Warehousing Interview Questions | Leave a comment

Where the Data cube technology is used? | Data Warehousing Questions

A multi-dimensional structure called the data cube. A data abstraction allows one to view aggregated data from a number of perspectives. Conceptually, the cube consists of a core or base cuboids, surrounded by a collection of sub-cubes/cuboids that represent the … Continue reading

Posted in Data Warehousing Interview Questions | Leave a comment