DSXchange

Dear Talent Pool,
What would be the maximum data volume size Information Analyzer support? I know this question looks silly; but, in my Organization some of the DataStage supporting groups complaining about the Information Analyzer performance. Can anyone tell me what would be the Ideal data volume size to work with Information Analyzer? Thank You.

The ideal volume is "all you've got". The most accurate answers are to be had by profiling all the rows in a table. Don't try to do too many tables at once - they can be scheduled to run consecutively if desired.

What do they mean by "performance"? Could they do it any faster by writing the myriad SQL statements needed to achieve the same results?

If the issue is the impact on the source system, take a snapshot of the source system and profile the snapshot.

But do make use of the scheduler - soak up the free cycles of the analysis engine.

Thank you Ray.