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.
Write down a short note on the difference between partial specialization and total specialization.
Describe the three types of data sources which are used with ODBC?
What are the Features of Monopoly?
Will I find several users to network with, if I use NetLib? Answer: NetLib has been around in 1986, and has over users that are 20,000, world-wide. You will simply f
Explain the four kinds of indexes?
Specify different types of transformations available in the Informatica?
Describe briefly the term Session and Batches?
Specify the user profiles within the Supervisor?
Illustrates the quickest sorting method to use?
Write down the differentiation between view and materialized view?
18,76,764
1931366 Asked
3,689
Active Tutors
1430773
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!