Virtual University Forum

Today CS614 Midterm Term Paper List down four basic tasks of data transformation? Data Transformation ƒ  Basic tasks ƒ  Selection ƒ  Splitting/Joining ƒ  Conversion ƒ  Summarization 5.      ƒ  Enrichment Identify the given statements as correct and incorrect "The approach of TQM refers to the involvement of only 20% employee inthe continuous improvemnt process" and 2nd statement  was "orr's law says that data quality is a function of its use not its collection" Solution: 1 st is wrong 2 nd is right Stat 1. TQM  approach  is  advocating  the  involvement  of  all  employees  in  the  continuous improvement process, the ultimate goal being the customer satisfaction. Stat: Law #2:  “Data quality is a function of its use, not its collection!”  Identify the given statement as correct and incorrect "in Molap the complexity cannot go beyound o(1) in any case" 2nd sta...

Today  paper of cs614 Two drawbacks of MOLAP (2) What are the syntactical errors? (2) Aggregates are generated by given data can we do vice versa? Support your answer with example (3) What are the effects if govt. uses dirty data (3) Operations of MOLAP with an example (5) Given statements are correct or incorrect (5)

Today-Mid-cs614- paper Assalam o Alaikum! About half MCQs from previous mid and final files (see only up to page 193 from final MVQs files). Half th4e MCQs were new and I did about 5 correct (sure) , So paper was OK for me. Here r MCQs which I did wrong, I wrote on paper only the answers , I attempted and now have checked and most of these are wrong. Very tricky MCQs. One MCQ The data is extracted completely from the source system. Since this extraction reflects all the data currently available in the source system, there's no need to keep track of changes to the data _______ since the last successful extraction. if u do full extraction then no need to record changes in ________. Source, destination, DWH. Page=133, I attempted DWH and it is wrong correct is Source One MCQ about data in flight (page 152), I had no idea if data can also fly so attempted wrong. One MCQ was if grains r increased then what increases. In Solved MCQs it was details but in Lecture 14 at 54:05 minutes and ...

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. 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 sta...