Maximum Number of Rows in All Frequency Distrubution report

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
sreeramkumart
Participant
Posts: 9
Joined: Tue Nov 27, 2007 10:59 pm

Maximum Number of Rows in All Frequency Distrubution report

Post by sreeramkumart »

Hi,

I have done Column analysis on a table for few columns. I am trying to genarate All frequency Distribution report on that table. The maximun number of column values iam getting for a particular field are 32000. When i ran a SQL query on that particluar column, i am getting more than 32000 column values. I have observed this scenario for two to three reports.

Are there any settings to get the complete report (instead of only 32K). Please Help.


Thanks in Advance.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There's no limit of which I'm aware in the PSDB, but there may be a limit in the viewer (client) that you're using.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sreeramkumart
Participant
Posts: 9
Joined: Tue Nov 27, 2007 10:59 pm

Post by sreeramkumart »

When i am exporting to a flat file, its not giving the complete dump. How to get it?
Post Reply