Page 1 of 1
Re: Re-platforming proprietary data to Teradata - URGENT!
Posted: Fri Sep 14, 2007 7:07 am
by chulett
Ah... you will be whacked for use of the 'U' word, and in all caps in the subject at that.
Please explain this little snippet from your post:
throbinson wrote:The job must run real time
Posted: Fri Sep 14, 2007 7:19 am
by throbinson
Good catch!
The source system is available for upload in approximately 1-4 hour windows throughout the day. The power supply is cached and requires a refresh at these intervals for about an hour I would guess. I haven't had time to benchmark this since the source system arrived only yesterday.
Brevis esse latoro obscurus fio.
Posted: Fri Sep 14, 2007 8:12 am
by chulett
Sorry, but I don't speak French.
Posted: Fri Sep 14, 2007 2:25 pm
by ray.wurlod
Do these managers have pointy hair, by any chance? How big are the rows? Can TPump, running standalone, achieve these benchmarks? (If not, then clearly DataStage driving TPump will not be able to. Don't sign up for anything doomed to failure - push back against unrealisitic demands - the more acceptable term for this is "expectation management".) Make your own benchmark, using two-byte rows, just to illustrate how pointless their requirement is.
Can't you convince them that MultiLoad sounds cool too?
You certainly seem to have enough AMPs, provided they're not being used for other things.
Posted: Thu Sep 20, 2007 12:05 pm
by rwierdsm
Having just delivered an app using TPump as the load utility, I can assure you that TPump WILL NOT be the fastest solution. TPump's purpose is essentially to allow trickle feeds. We used TPump for our lower volume tables (to satisfy the pointy haired boss's requirement for 'cool') and used MLoad for the heavy lifting.
Rob
Posted: Thu Sep 20, 2007 2:41 pm
by throbinson
Well played. I give.