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)
RE: Suppose one flat file taking loading time of 3 hr...
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.
RE: Suppose one flat file taking loading time of 3 hr...
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
RE: 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)
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.
