max size of inmemory file/table

[kavuri]

Hi,

can anybody tell me what is the max size of a file or table which we can maintain in a datastage job so that I can lookup for. I want to build this file everytime whenever I run my job.

Thanks
Kavuri

[ArndW]

The physical system limits are quite large, most likely limited by the amount of memory you have and disk space you allocate or point to in the configuration files.
The practical limits to file size are much smaller - think of how long it takes to build the lookup table.