We are in process of finding percentage of number values in character field
Is there is any way to the same ?
percentage of number values in character field
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY
We have nearly 5000 tables and running reports on them by importing metadata and running reports on them by doing a analysis has become a tedious task.
And each table has more than million records and running reports has been a performance issue
We were just looking for a Datastage/Quality stage solution where we can automate this process using a single job
And each table has more than million records and running reports has been a performance issue
We were just looking for a Datastage/Quality stage solution where we can automate this process using a single job
Althaf
-
- Participant
- Posts: 47
- Joined: Tue Feb 23, 2010 12:16 am
- Location: CHENNAI
Re: percentage of number values in character field
If you are Using DB2 You can convert into nums and U can do calculationAlthaf6553 wrote:We are in process of finding percentage of number values in character field
Is there is any way to the same ?
-
- Premium Member
- Posts: 278
- Joined: Wed Oct 03, 2007 8:45 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use Information Analyzer. That's what it was made for.
Sure it's tedious - but the tool absorbs most of the tedium - all you have to do is to review the results (in this case the frequency distribution of formats). You can even generate a report.
Sure it's tedious - but the tool absorbs most of the tedium - all you have to do is to review the results (in this case the frequency distribution of formats). You can even generate a report.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY