Hot file size

[sairaochowdary]

Hi Anybody
Could you please let me know ,is there any limitation on size of hotfile(Maximum size).I need to create a hotfile according to my requirement

Thanks
Sairaochowdary

 

[griffindm]

Sairaochowdary,

Hotfile have a limited amount of uses these days. If the data originates in the same database, then either a view or using another report as a data source is a better option. If the data is from another data source, some form of data replication can often do a better job, especially is that other source is static or slow moving. The only limitation with a report data source I have found is that it does not seem to respect an outer-join condition in the catalog, and behaves as if an inner-join had been specified.

If a hotfile is what you truly require, then be prepared to pay a performance penalty as the hotfile increases in size. I am not aware of an absolute maximum size stated for hotfiles.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com