How to validate existing data in a table

  • 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

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply