Records Reconcilition

foryou · Post by **foryou** » Mon Apr 13, 2009 6:00 pm

Hi Guys,

I am looking to build a job which can do the record reconciliation from source to target ie it can count the number of records pulled from source (oracle),
count the number of records rejected & count the number of records loaded into target (Oracle ) .

What' best practice to follow?

Anybody has got template?

Also tried to search the forum with words job/record reconciliation.
Are there any posts on it already on forum?

Shall appreciate any suggestions

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Apr 13, 2009 7:25 pm

Download ETLstats from Kim Duke's website - it's got all you want and more (unless you want some really arcane stuff).

kduke · Post by **kduke** » Tue Apr 14, 2009 8:46 am

Do a search on completeness. This is a few jobs which are included in EtlStats. It will create source counts and target counts and run a report after every load showing the percentage of records which ended up in the target. It should pass any kind of audit. You can easily add revenue or other measures and show their percentage of completeness. We even used it to show completeness of our lookups on dimension tables. If you count the number of unknown keys used in your fact table on a given dimension then you know this completeness percentage.