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
records handled by ti
-
Steve Rowe
- Site Admin
- Posts: 2464
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: records handled by ti
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
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
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
Michel Zijlema
- Site Admin
- Posts: 713
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: records handled by ti
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
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