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.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • 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