Interview Questions

What is Data warehouse - ETL?

ETL (extract, transform, and load) Testing Interview Questions


(Continued from previous question...)

22. What is Data warehouse - ETL?

In 1980, Bill Inmon known as father of data warehousing. "A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management's decision making process".
Subject oriented : means that the data addresses a specific subject such as sales, inventory etc.
Integrated : means that the data is obtained from a variety of sources.
Time variant : implies that the data is stored in such a way that when some data is changed.
Non volatile : implies that data is never removed. i.e., historical data is also kept.
Yes. However, modifying some fields, notably those related to bug progression states, also require adjusting the program logic to compensate for the change.
There is no GUI for adding fields to Bugzilla at this time.

(Continued on next question...)

Other Interview Questions