Friday, 26 December 2014

General and Advanced ETL Testing Interview Questions

ETL Testing Interview Questions

General Questions

• What is a three tier data warehouse?
• What are OLTP and OLAP?
• Who are the participants of data warehouse testing?
• What is Master data management?
• Mention what are the types of data warehouse applications and what is the difference between data mining and data warehousing?
• Explain what is tracing level and what are the types?
• Explain what is Grain of Fact?
• What is MDM (Master data management) ?
• What is Full load & Incremental or Refresh load?


 General ETL Interview Questions

• What is ETL?
• What is ETL process? How many steps ETL contains?
• Why ETL testing is required?
• What are ETL tester responsibilities?
• Explain ETL testing life cycle?
• Explain ETL Mapping Sheets?
• How many types of ETL Testing?
• Mention few Test cases and explain them
• How to prepare test cases for ETL / Data Warehousing testing?
• How many types of Bugs in ETL?
• Explain what are the ETL testing operations includes?
• What are the various tools used in ETL?
• How to fine tune mappings?
• What are the differences between SQL Override and Update Override?
• Data Warehouse Testing vs Database Testing
• Who are the participants of data warehouse testing

Advanced ETL interview Questions

• In your project you are using which type of data base and how much space ?
• What is tracing level? How many types of transformations supported by sorted input?
• If there are ten thousand records in a source system, how do we ensure that all ten thousand are loaded to the target without any dysfunctional values?
• I have ten records in my source system but I need to load only 2 records to the target for each run. How do I do this?
• Give some examples of real time data warehousing
Posted by at
Labels:

8 comments:

  1. Unknown21 September 2015 at 02:14

    brillant piece of information,this blog is fantastic...for more details

    http://www.tekclasses.com/

    ReplyDelete
    Replies
    1. Unknown28 July 2021 at 03:14

      IntelliMindz is the best IT Training in Bangalore with placement, offering 200 and more software courses with 100% Placement Assistance.

      ETL Testing Course In Bangalore
      Selenium Training In Bangalore
      Power BI Course In Bangalore
      Splunk Training In Bangalore

      Delete
  2. Unknown21 September 2015 at 02:32

    Very nice and informative blog.Nice piece of knowledge!For more details

    http://www.tekclasses.com/

    ReplyDelete
  3. Anonymous13 November 2015 at 08:20

    To get more information about the best transformation tools, you may visit our youtube channel. To transform any data into any database fast and easily ETL tools are required. There are so many useful tools. People from all over the word can use whenever they need to transform any data into any database faster.
    https://www.youtube.com/channel/UCvfiLK8W26L9PqUYaohcWZQ

    ReplyDelete
  4. Unknown26 November 2015 at 03:00

    Thanks for giving Good Example. Very well written. We are Providing Online training classes<a href=" http://www.ithubonlinetraining.com/oracle-adf-online-training/>ETLTestingonlinetraining</a>

    ReplyDelete
  5. david28 December 2015 at 02:23

    Thanks for providing information. It was very nice topic and it is very useful to Testing tools learners. We also provide online training classes.
    ETL Testing Online Training

    ReplyDelete
  6. Unknown16 September 2016 at 03:26

    Very good and unique collection of questions and answers thank you for sharing this information. Know more about ETL Testing Online Training

    ReplyDelete
  7. Lavanya6 December 2021 at 22:22

    I have found great and massive information on. Thanks for sharing
    Msbi Course
    Msbi Training

    ReplyDelete

Subscribe to: Post Comments (Atom)