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.
Why do not you utilize GNU SCONS or autoconf for building?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
State the components of report studio?
Explain the Stored Procedure transformation?
Explain the Aggregate Awareness?
Where is the GRANT table option usually done after creating tables dynamically within the Teardata? While tables are newly created, what are the default role and default privileges that get assigned?
Explain the way to swap a db device along with other.
Illustrates the Delete commands.
Explain about the DBMS.
How simple is NetLib to utilize?
18,76,764
1922962 Asked
3,689
Active Tutors
1460258
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!