Post reply

Data validation

  • August 5, 2016 at 9:29 am

    #315955

    I have two tables. table 1(source) and table 2(destination),They tie out in most months but not for 3 months, How to figure out the root cause…

  • August 5, 2016 at 10:21 am

    #1894089

    Aaryan (8/5/2016)

    I have two tables. table 1(source) and table 2(destination),They tie out in most months but not for 3 months, How to figure out the root cause…

    Rerun the ETL in a test version of the database, for the months in question and reproduce the problem.

    Isolate the differences.

    Look for a pattern.

    Identify the problem.

    Fix it.

    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

Viewing 2 posts - 1 through 1 (of 1 total)

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