percentage of number values in character field

[Althaf6553]

We are in process of finding percentage of number values in character field

Is there is any way to the same ?

[stuartjvnorton]

Use Information Analyzer. This is what it was made for.

[Althaf6553]

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

[manoj_23sakthi]

We are in process of finding percentage of number values in character field

Is there is any way to the same ?

If you are Using DB2 You can convert into nums and U can do calculation

[sjfearnside]

If you have a quality Stage license, you may be able to use the investigate stage.

From QS document: The Investigate stage looks at each record, column by column, analyzing the data content of the columns that you specify.

[ray.wurlod]

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.

[Althaf6553]

As a solution:

I have used Num(Field) function to get the output as 1 which i later aggregated to get the sum of numeric values and applied a percentage on the total table count to get the percentage of numeric values in a charecter field

Please share risks if any in the above approach