Sanity Check Poll
Moderators: chulett, rschirm, roy
Sanity Check Poll
Sanity Check Poll
1. Do not know what it is.
2. Know what it is but never seen it implemented anywhere.
3. Know what it is do not like it and never implement one. Kimball and Inmon are idiots.
4. Know what it is. Seen it implemented but think it is not useful.
5. Know what it is. Think it is valid QA technique.
6. Know what it is. Implement it every chance I get.
1. Do not know what it is.
2. Know what it is but never seen it implemented anywhere.
3. Know what it is do not like it and never implement one. Kimball and Inmon are idiots.
4. Know what it is. Seen it implemented but think it is not useful.
5. Know what it is. Think it is valid QA technique.
6. Know what it is. Implement it every chance I get.
Mamu Kim
Kim, perhaps an explanation of what that is in the context of DataStage would help? Or is that meant to be part of poll, a.k.a. the first answer? We always do something I would consider to be a "sanity check" but no clue how closely that ties in to any sort of official... thing.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
The CFO approves the budget for all departments. You want more money then make him/her happy. You want more developers same answer. Want more money as a consultant then know what a Sanity Check is and how to implement it. Same goes for being a DataStage admin. The more roles you know the more valuable you are on a team. Mentor somebody and make the team look better. You will all get paid more.
Take the poll. Help us understand what you know so we can help mentor you.
Take the poll. Help us understand what you know so we can help mentor you.
Mamu Kim
Here is the video on our tool that does a Sanity Check.
Auditing Tool - Overview
https://youtu.be/HvLv8OVnlzY
Description:
1. Quality Assurance tool for Sanity Checks
2. Completeness Reporting
3. Quick setup
4. Fast retrieval of measures
5. Flexible - any SQL statement that returns 1 numeric value can be used.
6. Complete audit trail
7. Textbook perfect solution
30:52
Auditing Tool - Overview
https://youtu.be/HvLv8OVnlzY
Description:
1. Quality Assurance tool for Sanity Checks
2. Completeness Reporting
3. Quick setup
4. Fast retrieval of measures
5. Flexible - any SQL statement that returns 1 numeric value can be used.
6. Complete audit trail
7. Textbook perfect solution
30:52
Mamu Kim
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
We "almost" always do some sanity check or reconciliation at the end of load for some key values. counts amounts for critical information. I prefer to know if there is a problem before business lads finding and start screaming. However I keep such sanity checks precise and minimum, limited to critical information.
But I like how the third option is phrased. I will go with that.
But I like how the third option is phrased. I will go with that.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
Thanks. Someone said why would I pay for that. It is just a few SQL statements. If your data warehouse has 200 tables and 5 sources then you need to 400 simple SQL statements to do a simple sanity check. You can't really do any trending based on those numbers because you do not store results. Is your revenue up or down? Is this a peak revenue time of year? Simple trending is easily accomplished by running reports against audit trail history. We even narrowed our trending to day of the week. We knew exactly what our revenue was per customer per day of the week. We could easily trend from year to year as well.
If CFOs find out this tool exists then it will be required on every data integration project. There are so many benefits from these simple tools that automate tasks nobody wants to do anyway. Spend a day setting up your source and target tables then see how cool this is. They people that don't want these numbers never ran a sanity check before. Like he said. If I can get the bad news before someone else does then we as developers are way ahead of the game. I always like to stay ahead of the other lads.
If CFOs find out this tool exists then it will be required on every data integration project. There are so many benefits from these simple tools that automate tasks nobody wants to do anyway. Spend a day setting up your source and target tables then see how cool this is. They people that don't want these numbers never ran a sanity check before. Like he said. If I can get the bad news before someone else does then we as developers are way ahead of the game. I always like to stay ahead of the other lads.
Mamu Kim
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI