1.

How will you perform data load testing?

Answer»

Data load testing requires the testers to know about source databases and the destination databases and their objects like tables, columns, design, constraints etc. While performing tests, we need to validate the compatibility of the source and destination databases using the DTS package in SQL Enterprise Manager. We can follow the below steps for the same:

  • OPEN the DTS package and run it.
  • Compare the column data of the source and destination tables.
  • Check for the NUMBER of rows in source and destination tables.
  • Post updating data in source tables, check if the same changes are reflected in the destination database.
  • Check about the data QUALITY WHETHER the destination data received any junk characters and NULL values.
  • Check for the maximum processable VOLUME on the servers and evaluate the response times and speed of data load from the source to destination.


Discussion

No Comment Found

Related InterviewSolutions