1.

What are the different challenges of ETL testing?

Answer»

In spite of the importance of ETL TESTING, companies may face some challenges when trying to implement it in their applications. The volume of data INVOLVED or the heterogeneous nature of the data makes ETL testing challenging.   Some of these challenges are listed below:    

  • Changing CUSTOMER requirements result in re-running test cases.
  • Changing customer requirements may necessitate a tester creating/modifying new mapping documents and SQL scripts, resulting in a long and tedious process.
  • Uncertainty about BUSINESS requirements or employees who are not aware of them.
  • During migration, data loss may occur, making it difficult for source-to-destination reconciliation to take place.
  • An incomplete or corrupt data source.
  • Reconciliation between data sources and targets may be impacted by incorporating real-time data.
  • There may be memory issues in the system due to the large volume of historical data.
  • Testing with inappropriate tools or in an UNSTABLE environment.


Discussion

No Comment Found

Related InterviewSolutions