I’ve been hard at work on a new On-line class (soon to be released). I’ve also added some templates to RapidACE v2 which generate automated DATA tests!!
Yep, that’s right, automated data testing against ANY Data Vault model that you can build. The tests that are generated are built to test the standards, and are setup to check the data sets in the database – ensuring the integrity of your ETL routines!!!
No, these tests do not test “did I map the right field in the stage to the right field in the Data Vault” – what they do test are things like: Business Key uniqueness, matching composite relationships, and more.
The data tests in the Data Vault model will test:
- Hubs
- Links
- Satellites
- Hierarchical Links
- Same-As Links
- Transaction Links
The data tests that I generate can be run ANY TIME there is a change to the ETL layers, or any time a new systems’ ETL is built to load data to the Data Vault.
The On-line course will teach you:
- How to test
- How the tests work
- What pass and fail mean for each test
- How to record the results
- Definition of each test (SQL and PseudoCode)
For now, I’m generating ANSI-SQL, by the end of next week I’ll be generating Informatica v9 Maps, Sessions, Workflows to run the data tests. When run in Informatica, it will be easy to see when tests fail – as they will fail the workflows.
IF YOU ARE INTERESTED IN:
- Having me generate these data test scripts for your Data Vault
- OR: having me generate these data tests in Informatica for your Data Vault
- OR: taking the up-coming on-line class
THEN Please, Contact me today.
Cheers,
Dan Linstedt
PS: This class will be made available at: http://LearnDataVault.com