Database Validation

[gwinrunner]

Hi Everybody,
My question is regarding Back end testing. How can i validate the data( millions of rows) which is loaded from different sources to the target Oracle data (post ETL).

Thanks

[slimdave]

A good start is to keep track of where every piece of data came from, the code path and version it was processed by, and when it was loaded.

So your tables might include the following columns and values:

DATA_SOURCE: "PAYROLL"
DATE_TRANSMISSION: "FILE00123"
LOAD_DATE: "01-jan-2004 23:15:27"
LOAD_PATH: "MOD1234.4"
LOAD_PATH_VERSION: "2.3.1"

That might seem a lot of bytes to add to each row but doubtless you'll be using data segment compression so in fact it will amount to very little.

Hope that helps ... maybe not quite the complete answer you were looking for but it works for me.