TM1 Forum

hi,
Can any one tell me the Max limit of the records that can be handled by a turbointegrator process?
i have 8000,000+ records in acess db which has to be tranfered to the tm1 cube...
is it possible through turbo to transfer data to cube??

regards,
Angel

There is no upper limit 800k records should be no problem.

The time taken to process the data will obviously vary according to the speed of the source and the amount of work your doing in the TI and any feeders that are being triggered when you write the data to the cube.

Cheers,

Steve

Hi,

TI can also handle 8 mln records, but I assume that data will be on an aggregated level in the TM1 cube. So I would advice, if possible, to already aggregate the source data in the selection query (using Group By, sum, count, etc.). This wil reduce the number of data lines to be processed by TI and thus the time needed for processing the source data.

Michel