Multiload and Fast Load estimation

Tools & Utilities
Enthusiast

Multiload and Fast Load estimation

Hi All,
I need to estimate the Multiload, FastLoad, and BTEQ scripts in project. Can any body tell me that which which things will consider in complexity of each Multi load, Fastload, and BTEQ jobs.... and the time for each activity..

Thanks in advance
2 REPLIES
N/A

Re: Multiload and Fast Load estimation

Hi,

Try running an SQL Explain for each DML statement on each utiliity to test the time it takes to execute that query. Then sum the time frame obtained from each explain results to check the total time accumulated. I hope this will help...

regards,

Siphiwe & Norman
Enthusiast

Re: Multiload and Fast Load estimation

thanks Mchunu,
for your reply..
Sorry, from my side, I didnt explain fully that what I am looking. Actually, I have to estimate a whole project, and there would be say n number or Multiloads, k number of BTEQs, and m number of Fastloads. We have to estimate complexity and time taken for Analysis, development, testing, moving to production etc for these newly Scripts. can Any Teradata guru provide the estimation technique to be used in Teradata...

Thanks in advance...