1.

In Data Base Testing, What Are The Steps To Test Data Loading?

Answer»

FOLLOWING steps need to FOLLOW to test data loading

  • Source data should be KNOWN
  • Target data should be known
  • Compatibility of source and target should be checked
  • In SQL Enterprise manager, run the DTS package after opening the corresponding DTS package
  • You have to compare the COLUMNS of target and data source
  • Number of rows of target and source should be checked
  • After updating data in the source, check whether the changes appears in the target or not.
  • Check NULLS and junk characters

Following steps need to follow to test data loading


Discussion

No Comment Found

Related InterviewSolutions