DWH Interview Questions


What is an ODS?


What is a Federated Data Warehouse?

What is a Virtual Data Warehouse?

What is an Enterprise Data Warehouse?

What are the different process maps available for Data Marts?

What is Top-Down architecture of Warehouse development?

What is Bottom-up architecture of Warehouse development?

What is Enterprise Data Mart architecture of Warehouse development?

What is Data Stage/ Data Mart architecture of Warehouse development?

What is Distributed Data Warehouse/ Data Mart architecture of Warehouse development?

What is Normalization, First Normal Form, Second Normal Form , Third Normal Form?
 1.Normalization is process for assigning attributes to entities–Reduces data redundancies–Helps eliminate data anomalies–Produces controlled redundancies to link tables
 2.Normalization is the analysis of functional dependency between attributes / data items of user views,It reduces a complex user view to a set of small and stable subgroups of fields / relations

1NF: Repeating groups must be eliminated, Dependencies can be identified, All key attributes defined,No repeating groups in table

2NF: The Table is already in1NF, includes no partial dependencies–No attribute dependent on a portion of primary key, Still possible to exhibit transitive dependency, Attributes may be functionally dependent on non-key attributes.

3NF: The Table is already in 2NF, Contains no transitive dependencies

Why do we need a different schema for Data warehousing/Business Intelligence?
 A data warehouse stores historical data that is collected from various sources and the data is time variant. The data warehouse is updated in a scheduled and controlled manner. An online system usually does not store historical data, however if history data is stored it would pose severe performance issues, further being an Online environment 2 users accessing the same set of information are likely to derive different results. An online system would provide data only from a single source, whereas a data warehouse usually has data being put in from various sources.

What are the various features of Enterprise Data Warehouse?
 The various features of an EDW are:
 An EDW may or may not interact with Data Mart. The most important aspect of any Data Warehouse is the consistency of information.
An EDW may have same level of granularity as a Data Mart. This means that the data from the Data Mart will be dumped into an EDW.
An EDW may have more detailed level of data than a Data Mart. This means that the data requirement is at a more granular level that may not be catered by the Data Mart. 

12 comments:

  1. Very useful information thank you for sharing. Know more about OBIEE Tutorials For Beginners

    ReplyDelete
  2. It is very useful information at my studies time, i really very impressed very well articles and worth information, i can remember more days that articles.

    Data warehousing Training in Chennai

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Nice Blog for a cost effective data warehouse software
    visit Data warehouse

    ReplyDelete
  5. To solve for the increasing challenges of the conventional data warehousing issues, I was concerned for the data warehouse service companies .

    ReplyDelete
  6. The article is very nice, thank you for sharing it! I'm not fully through yet (it is extremely long) but it seems well researched and detailed. free calling app
    Talk to strangers

    ReplyDelete
  7. This is a great way for companies to acquire and use data to make business decisions. A company can use thedata warehouse for a variety of purposes including payroll, inventory, and sales analysis.

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...