What is ETL? Why ETL testing is required? What is Data warehouse? What are the characteristics of a Data Warehouse? What is the difference between Data Mining and Data Warehousing? What are the main stages of Business Intelligence? What tools you have used for ETL testing? What is BI? What is a Data Warehouse? What is ETL? Explain what are the ETL testing operations includes? Mention what are the types of data warehouse applications and what is the difference between data mining and data warehousing? What are the various tools used in ETL? What is a fact? What are the types of facts? Explain what are Cubes and OLAP Cubes? Explain what is tracing level and what are the types? Explain what is Grain of Fact? Explain what factless fact schema is and what is Measured? Explain what is transformation? Explain the use of Lookup Transformation? Using SSIS ( SQL Server Integration Service) what are the possible ways to update the table? In case you have non-OLEDB (Object Linking and Embedding Database) source for the lookup what would you do? Explain what are the differences between Unconnected and Connected lookup? Explain what is data the source view? Explain what is the difference between OLAP tools and ETL tools ? Explain what staging area is and what is the purpose of a staging area? What is Bus Schema? Explain what is data purging? Explain what are Schema Objects? What is a Data Warehouse? What is a Data mart? What is OLAP? What is OLTP? What are Dimensions? What are Confirmed Dimensions? What are Fact Tables? What are the types of Facts? What are the types of Fact Tables? What is Factless Fact table? What are Measures? What are Cubes? What are Virtual Cubes? What is a Star schema design? What is Snow Flake schema Design? What is Operational Data Store [ODS] ? What is Denormalization? What is Surrogate Key? What are the differences between Database and Datawarehouse?