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.
Describe about generating a report tool by utilizing the report tool and the report wizard?
State the different types of the folders?
Explain the function of metadata for the three-layer architecture?
Explain the terms SQL Server and adaptive server enterprise?
How many modes are there in Business objects and Designer?
Write down the brief notes on multidimensional data model.
Explain the term Account and Directory options?
Elucidate briefly what is batch and also give explanation about the types of batches?
Describe briefly the ‘paradigm mismatch’ among SQL and application programming languages.
Write about the term metadata in brief.
18,76,764
1944562 Asked
3,689
Active Tutors
1425445
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!