DSXchange

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

Is there is any way to the same ?

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

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

Althaf6553 wrote: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

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.

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.

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