How to validate existing data in a table

• chetan06

  SSC Enthusiast

  Points: 187

  More actions

  December 24, 2023 at 9:59 am

  #4351639

  Hello Team,

  I have some application databases where i need to perform data validation. I am not sure what type of data is already stored in the tables. Does there are any set of pre-defined rules / constraints with which i am cross verify data ?

  Or i have to reply on the application team to provide me set of data rules which is compatible with application

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  December 24, 2023 at 10:05 pm

  #4351817

  You need to find out more from the person asking you to do this. Questions such as

  What sort of validation? Data within certain limits? Data has only predefined values? Data consistency? Data integrity?

  How frequently should the data be checked?

  What needs to happen when invalid data is found?

  Come immediately to mind.

  ---