1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Data Validation in Data Warehouse

Discussion in 'SQL PL/SQL' started by Ramayan, Jan 19, 2013.

  1. Ramayan

    Ramayan Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    India
    Hi Forum,

    What is data validation in data warehouse.
    I have this procedure which loads data into Data Mart from WH... how do I test it. The job runs every 15 min in scheduler.
    Is this validation process going to manual or is there any Automation tool.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,346
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Data validation does just what the name suggests -- validates that the aggregated data in the warehouse accurately reflects the source data. One normally writes a process to perform such validation tasks -- I suspect there are examples on the web to illustrate this.