All Forums UDA
syed_td 9 posts Joined 07/08
25 Aug 2008
TPT performance

Hi,What is the difference in the performance when using TPT and standalone utilities (Fast export,Fast load, Multi load and Tpump). Except that one generic script for all utilities.The document is saying TPT is fully parallel? Teradata it self is parallel environment then what is this TPT fully parallel?Is there any pdf or document where I can find the real difference between TPT and standalone utilities?ThanksSyed

j355ga 100 posts Joined 12/05
25 Aug 2008

Parallelism is increased over the traditional database parallelism by using file streams as opposed to writing to disk. This allows each data stream to be shared with multiple instances of each operator. This increases parallelism and speeds up the entire data load process.

Jeff

syed_td 9 posts Joined 07/08
25 Aug 2008

Thanks jeff.We have source files in the ETL server. We fast load data to staging tables. We fast export to files and send these files to FTP location.How this parallel is works here? Are standalone utilities use any kind of writing to disk activities for the above case ? Please correct me.I can see advantage like:1) When I see at ETL perspective, when joining multiple sources the result written to disk files. Then these disk files used for further processing. Here replaced data steam, as you said will improve the performance.2) When move data between prod to test. No need to do fast export then fast load or multiload. When use TPT, we can avoid one step.ThanksSyed

You must sign in to leave a comment.