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).
- What are the methods for data Transportation in a Data Warehouse.?
- What is the difference between “Initial Load” and “Refresh”
- What is Low Level Grain?
- List and Detail Loading Techniques Provided by Oracle?
- What is Summary Management?
- Wholesale Data Replacement.
- Explain the contents of a Database Log.
- Refresh mechanisms for materialized views.
- Maintaining History – Techniques (List in detail)
- Advantages of Versioning, Purging and Archiving