-
Log Table
What is log table? What is the use of log table?
-
Set and Multi Set Tables
What are set tables and multiset tables in Teradata?Explain with an appropriate example?
-
Which two can be implemented as a centrally located logical architecture?
č operational data storeč logical data mart
-
What are two examples of an OLTP environment?
č Transactions take a matter of seconds or less.č Many transactions involve a small amount of data.
-
What is a staging area? Do we need it? What is the purpose of a staging area?
Answered by Laxmi on 2005-05-13 16:42:53: Staging area is place where you hold temporary tables on data warehouse server. Staging tables are connected to work area or fact tables. We basically need staging area to hold the data , and perform data cleansing and merging , before loading the data into warehouse.