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
Apr 4th, 2006
3
1575

Informatica

Answer

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
Profile Answers by 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.