60. What is difference between BO, Microstrategy and Cognos

61. how data in datawarehouse stored after data has been extracted and transformed from hetrogeneous sources and where does the data go from datawarehouse.

62. what is the difference between star schema and snow flake schema ?and when we use those schema's?

63. what is the difference between Datawarehouse and Datawarehousing

64. what is data cleaning?

65. How do you load the time dimension

66. What are the Different methods of loading Dimension tables

67. What is Difference between E-R Modeling and Dimentional Modeling.

68. what is the need of surrogate key;why primary key not used as surrogate key

69. What is a linked cube?

70. What is surrogate key ? where we use it expalin with examples

71. Summarize the differene between OLTP,ODS AND DATA WAREHOUSE ?


72. what is cube and why we are crating a cube what is diff between etl and olap cubes any budy a what is cube and why we are crating a cube what is diff between etl and olap cubes any budy ans plz?

73. what is conformed fact?

74. What is meant by metadata in context of a Datawarehouse and how it is important?

75. which automation tool is used in data warehouse testing?

76. what is the differences between the static and dynamic caches?

77. What is a lookup table


78. what are the steps to build the datawarehouse

79. what is the definition of normalized and denormalized view and what are the differences between the what is the definition of normalized and denormalized view and what are the differences between them