DataStage assets to perform different levels of table comparison
Just deploy the lastest released isx file and configure jdbc drivers if necessary. Find all releases here: https://gitlab.com/nsitbim/satellites/dsplus/datastagetnr/-/releases And download the artifact.
All assets are deployed in the T_NR folder.
1- Edit the ParameterSet to declare all databases accordingly
2- Either run the jobs individually or from the sequence
Each job takes 2 arguments:
- the table to compare
- the reference to the ParameterSet
This is not intendend to be performant. It is more a proof of concept.
LOBs and float are not handled well so they have to be dropped or converted (see job documentation for more information)
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
Please make sure to update tests as appropriate.