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
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • 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