Question details

Week 6 key term
$ 25.00

Write out, define & submit the terms below. Do this assignment in Microsoft Word.  The "file_name" must include your last name first, first name and the week -: e.g.  Jhala_Nilyum_Week6.doc by Sunday Night @ 12:00 Midnight.

Inside the document you must have a proper heading including your full name, course name, week # and your email address.

Here are the terms:

My expectation is a “Detailed Description” where necessary otherwise a carefully crafted and logically organized “Point by Point” list. (Use your best judgment).

  1. What are the methods for data Transportation in a Data Warehouse.?

 

  1. What is the difference between “Initial Load” and “Refresh”

 

  1. What is Low Level Grain?

 

  1. List and Detail Loading Techniques Provided by Oracle?

 

  1. What is Summary Management?

 

  1. Wholesale Data Replacement.

 

  1. Explain the contents of a Database Log.
     
  2. Refresh mechanisms for materialized views.

 

  1. Maintaining History – Techniques (List in detail)

 

  1. Advantages of Versioning, Purging and Archiving

 

Available solutions