FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Nonvolatile means that, once entered into the warehouse, data should not change. This is logical because the purpose of a warehouse is to enable you to analyze what has occurred.

Detailed explanation-2: -It is non volatile Database, once the data entered into the database, it does not reflects to the change which takes place at operational database. Hence the data is statics in Data Warehouse.

Detailed explanation-3: -To update a table in a data warehouse by using a set of load output files, complete the following tasks: Set the options for the load utility control statements. Generate the load output files. Apply the load output files to the warehouse table.

Detailed explanation-4: -Answer-D) Volatile is not a property of the data warehouse.

Detailed explanation-5: -3 Time Variant Non-volatile: It means that, once entered into the data warehouse, data should not change. A different version of data is stored in the data warehouse indicating if any insert, update or delete have occurred in the database. Hence, the original data is never altered.