Home

Logical Flow of Ad-Hoc Data Comparisons

Logical Flow of Package Runtime Regression Test

Start of Package

1. Before anything else, the package calls the DQMF.dbo.SetAuditPackageExecution

DQMF.dbo.SetAuditPackageExecution

1. gets a new PkgExecKey int variable (that uniquely identifies this particular package execution)
2. saves PkgExecKey as SSIS variable
3. calls AutoTest.dbo.uspInitPkgRegressionTest

AutoTest.dbo.InitPkgRegressionTest

1. inserts rows from DQMF.dbo.ETL_PackageObject mapping table into AutoTest.dbo.TestConfig table a. creates TestConfigID for each ObjectID for this PkgID
2. cursor over rows of AutoTest.dbo.TestConfig for this PkgExecKey a. create simple SELECT * FROM query for each table/view referred to by ObjectID b. call AutoTest.dbo.uspCreateQuerySnapShot which creates a physical snap shot table in AutoTest.SnapShot schema

Package runs normally

End of Package

1. calls the DQMF.dbo.SetAuditPackageExecution for this PkgExecKey
2. calls AutoTest.dbo.uspInitPkgRegressionTest for this PkgExecKey

AutoTest.dbo.uspPkgRegresionTest

1. cursor over rows of AutoTest.dbo.TestConfig for this PkgExecKey a. create simple SELECT * FROM query for each table/view referred to by ObjectID b. call AutoTest.dbo.uspCreateQuerySnapShot which creates a physical snap shot table in AutoTest.SnapShot schema c. call AutoTest.dbo.uspDataCompare for these pre and post snap shots

AutoTest.dbo.uspDataCompare