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.
Give brief introduction of the term breakpoint in SSIS?
Explain the linked universes?
Name the methods and types of Collision Resolution Techniques used in each of the type?
Write down brief note on the differentiation between dynamic cache and static cache?
Write a brief note on the market basket analysis?
Provide a brief introduction of the term slowly changing dimensions (or SCD)?
Illustrate the term indexing. Specify the kinds of the indexing.
Explain the object qualification?
Specify the use of data stage designer?
What the difference between sequential file stage and hashed file stage is in relates to DataStage Server?
18,76,764
1950432 Asked
3,689
Active Tutors
1415025
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!