80. Give examples of degenerated dimensions

81. What are the methodologies of Data Warehousing.


82. What is data mining


83. What is meany by survey and extraction tables in DW?


84. What is the difference between view and materialized view


85. What is Replicate,Transparent and Linked cubes?


86. What is the main difference between Inmon and Kimball philosophies of data warehousing?

87. what are the advantages data mining over traditional approaches?


88. wht r the data types present in bo?n wht happens if we implement view in the designer n report


89. What is Normalization, First Normal Form, Second Normal Form , Third Normal Form

90. what is data validation strategies for data mart validation after loading process

91. Differences between star and snowflake schemas


92. What is real time data-warehousing

93. Which columns go to the fact table and which columns go the dimension table


94. What does level of Granularity of a fact table signify


95. What is the main differnce between schema in RDBMS and schemas in DataWarehouse....?


96. What is degenerate dimension table?
97. Information Packages(IP) are advanced by some author as a way of building dimensional models - e.g. Information Packages(IP) are advanced by some author as a way of building dimensional models - e.g. star schemas. Explain what IPs are and Give an example of it\'s use in building a dimensional model.


98. What is VLDB

99. What is a general purpose scheduling tool

100. What are Aggregate tables

101. Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs

102. How are the Dimension tables designed

103. Why should you put your data warehouse on a different system than your OLTP system

104. What is a level of Granularity of a fact table