by on December 24, 2013 at 6:25pm
My Today Paper
Q.NO 1:
purpose of aggregate awarneness.
Solution:
Aggregate awareness allows using pre-built summary tables by some
front-end tools.
front-end tools.
the environment is smart enough to develop or compute higher level aggregates using lower level or more detailed aggregates.(ye statement mcq mn b thi)
Q.NO 2:
Two steps of BSN method:
Solution:
Steps 1: Create Keys
Step 2: Sort Data
Step 3: Merge
Q.NO 3:
" No single key is sufficient to catch all matching records" this is the limitation of BSN .what can we do to avoid this limitation?
Solution:
Page NO 177
Q.NO 4:
"performance increase with the use of disk space" which factor lead to relation between performance and disk space?
Solution:
I think its is De Normalization because denormalization increase performance(plz check)
Q.No 5
Identify types of transformation
"a data element form the source system results in several columns in the DW"
second yad ni
Solution:
1st statement is one to many
2nd was many to many
Q.NO 6:
Roll up and Drill down with example
Solution:
Rollup: summarize data
e.g., given sales data, summarize sales for last year by product category
and region
Drill down: get more details
e.g., given summarized sales as above, find breakup of sales by city within
each region, or within Sindh
e.g., given sales data, summarize sales for last year by product category
and region
Drill down: get more details
e.g., given summarized sales as above, find breakup of sales by city within
each region, or within Sindh
Comments
Post a Comment
Please give us your feedback & help us to improve this site.