[go: up one dir, main page]
Menu ▾ ▴

Tree [351d13] 1.3.x 1.3.0 / ETL / TableCompare /
 History

HTTPS git://
HTTPS access

File Date Author Commit
 CompareDatabaseTables.kjb 2011-05-17 John Woodlock John Woodlock [471ebe] Merge branch 'master' into 1.2.x
 CompareDatabaseTables.ktr 2011-05-18 John Woodlock John Woodlock [984c6e] MIFOSBI-47 - Create ETL Job that updates DW inc...
 README 2011-05-22 John Woodlock John Woodlock [e30c8f] documentation update
 compareDatabases.sh 2011-05-22 John Woodlock John Woodlock [dd1aea] MIFOSBI-47 add linux compare database shell scr...
 kff-plugins4.jar 2011-03-29 John Woodlock John Woodlock [f74cd8] MIFOSBI-47 - Create ETL Job that updates DW inc...

Read Me

For table compare to work (and its used when testing full reload vs incremental ETL) 
then kff-plugins4.jar has to be put in the pdi directory plugins/steps 


Table compare uses 2 jndi settings DB1 and DB2

Output goes to the $PDI_HOME directory (data-integration)
Summary output -> ComparisonStatistics.txt
Error output -> ComparisonErrorDetails.txt

Job currently compares data warehouse databases but could be for any db 
by changing step "Get DW Table Names" in CompareDatabaseTables.ktr

Quick when no errors... much slower when loads of errors.