InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What is a slowly changing dimension and what are its types? |
| Answer» | |
| 2. |
What do you understand by fact-less fact table? |
| Answer» | |
| 3. |
What do you understand by Normalization? |
| Answer» | |
| 4. |
What is Self-Join? |
| Answer» | |
| 5. |
What is the difference between shortcut and reusable transformation? |
| Answer» | |
| 6. |
Which SQL statements can be used to perform Data completeness validation? |
| Answer» | |
| 7. |
Name a few checks that can be performed to achieve ETL Testing Data accuracy. |
| Answer» | |
| 8. |
I have 50 records in my source system but I want to load only 5 records to the target for each run. How can I achieve this? |
| Answer» | |
| 9. |
What do you call the testing bug that comes while performing threshold validation testing? |
| Answer» | |
| 10. |
What do you understand by a cosmetic bug in ETL testing? |
| Answer» | |
| 11. |
What is data purging? |
| Answer» | |
| 12. |
What are the common ETL Testing scenarios? |
| Answer» | |
| 13. |
Name the three approaches that can be followed for system integration. |
| Answer» | |
| 14. |
How does duplicate data appear in a target system? |
| Answer» | |
| 15. |
Write an SQL statement to perform Duplicate Data check Testing. |
| Answer» | |
| 16. |
What do you understand by Threshold value validation Testing? Explain with an example. |
| Answer» | |
| 17. |
If there are thousands of records in the source system, how do you ensure that all the records are loaded to the target in a timely manner? |
| Answer» | |
| 18. |
What is the difference between surrogate key and primary key? |
| Answer» | |
| 19. |
What is a surrogate key in a database? |
| Answer» | |
| 20. |
What is lookup transformation and when is it used? |
| Answer» | |
| 21. |
Explain the terms − mapplet, session, mapping, workflow − in an ETL process? |
| Answer» | |
| 22. |
What is the difference between round-robin partitioning and Hash partitioning? |
| Answer» | |
| 23. |
What is Partitioning? Explain different types of partitioning. |
| Answer» | |
| 24. |
What do you understand by Active and Passive Transformations? |
| Answer» | |
| 25. |
What do you understand by the term ‘transformation’? |
| Answer» | |
| 26. |
What are your responsibilities as an ETL Tester? |
| Answer» | |
| 27. |
Explain the key challenges that you face while performing ETL Testing. |
| Answer» | |
| 28. |
What are the different ETL Testing categories as per their function? |
| Answer» | |
| 29. |
How ETL Testing is different from database testing? |
| Answer» | |
| 30. |
What do you understand by ETL Testing? |
| Answer» | |
| 31. |
Explain ‘Group-by’ and ‘Having’ clause with an example. |
| Answer» | |
| 32. |
What is the difference between Minus and Intersect? What is their use in ETL testing? |
| Answer» | |
| 33. |
What are the common set operators in SQL? |
| Answer» | |
| 34. |
What is an Operator in SQL? Explain common operator types. |
| Answer» | |
| 35. |
Explain the difference between DDL, DML, and DCL statements. |
| Answer» | |
| 36. |
What is an Aggregate function? Name a few common aggregate functions. |
| Answer» | |
| 37. |
What is a Data Mart? |
| Answer» | |
| 38. |
What is a Dimension table and how is it different from a Fact table? |
| Answer» | |
| 39. |
What are the structural differences between an OLTP and OLAP system? |
| Answer» | |
| 40. |
What is the difference between data warehousing and data mining? |
| Answer» | |
| 41. |
Why do we need a staging area in an ETL process? |
| Answer» | |
| 42. |
What are the popular ETL tools available in the market? |
| Answer» | |
| 43. |
What is the difference between and ETL and BI tools? |
| Answer» | |
| 44. |
Explain the 3-layer architecture of an ETL cycle. |
| Answer» | |
| 45. |
What do you understand by an ETL? |
| Answer» | |