How to reduce load times

Suppose one flat file taking loading time of 3 hrs.
How u can reduce that loading time to 1 hr.
( No FTP, Not UNIX system to make parallel processing,No splitting file,and all servers and files and targets existing in same system)
  • Interview Candidate
  • 3
  • 1590

Showing Answers 1 - 3 of 3 Answers

sonal

  • Aug 16th, 2006
 

If your session reads from a flat file source, you can improve session performance by setting the number of bytes the PowerCenter Server reads per line.

UmaBojja

  • Aug 14th, 2007
 

One can use Nway partition at the source side.
We have to partition the session and give the source file name only for the first partition.Server will automatically takecare.
Please check if you have that feature. It a new feature started from 7.1.2

Thanks
Uma Bojja

rags.sarath

  • May 20th, 2008
 

If ur source is flat file,the pcs reads 1024 bytes perone line.If the line containg the bytes  less than this number to improve session performance u can tune the 'Line sequntial buffer lenth" in session  properties.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions