Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Assuring Data Quality Expand / Collapse
Author
Message
Posted Tuesday, October 12, 2010 11:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 20, 2012 7:25 PM
Points: 6, Visits: 74
I like the idea of parking bad data in a DQ database and tracking it's status each load until it is fixed in the source system. (Building a Data Warehouse With Examples in SQL Server)
I don't know how this would go when you are dealing with a relational data warehouse that has foreign keys. Do you also need to identify any children of the bad record and park them too?

I'd like to make this work, as it seems to be pretty comprehensive, but it has to work in a relational structure for us.
Post #1003359
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse