Aggregate tables and lookup tables
Briefly describe the employ of aggregate tables and lookup tables?
Expert
Updating the data warehouse, a lookup table is employed. When placed on the fact table or warehouse depended on the primary key of the target, the update is happens only by permitting new records or updated records depending on the condition of lookup.
The appeared views are aggregate tables. It holds summarized data. For instance, to make sales reports on monthly or weekly or yearly basis in place of daily basis of an application, the date values are aggregated in week values, week values are aggregated in month values and month values in year values. To play this procedure @aggregate purpose is employed.
Explain the Data Transformation Manager (DTM)?
What are the features of Monopolistic Competition?
Which efficient data structure is used in RDBMS, for internal storage representation?
States the term Star Schema?
You have two tables, STUDENT and COMPUTER which are in a one-to-one relationship. The foreign key is StudNumber in COMPUTER that references StudNumber as the primary key of STUDENT. Describe what must be done to convert the one--to-one STUDENT -COMPUT
Explain an unsupported method to shrink a database.
Define the term Data Independence?
What do you mean by the term stored procedure in the Teradata?
Illustrates the applications of ASA?
Briefly describe the differentiation between data warehouse and OLAP?
18,76,764
1942276 Asked
3,689
Active Tutors
1457999
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!