DSXchange

currently we are generating flatfiles in datastage and then these files are sftped to the SAPBW server. the SFTP part takes a long time.
Could you plz throw some light on this.

Currently we are creating Flatfiles in Datastage and then these flatfiles are SFTPed to the SAPBW server and after that ,jobs in BW populate their data targets using these Flatfiles (.csv file). The whole thing , ie the data to go from oracle Database to BW data Targets takes 2.5 Hrs. I thought may ...

Hi all, I am working with DataStage Version 7.5.1.A and i am expieriencing a significant Performance loss while using Load PACK stage :twisted: ( ie it takes a lot of time to complete the Job). Can anyone share his experience of working with LOAD PACK stage, the performance that load pack gave and a...

when i tried to read data from Oracle Database and write it to Sequential file , the job took just 10 minutes and when instead of Sequential File i am using SAPBW LOAD PACK (to send the data to SAP BW server) , its taking more than 2.5 Hrs to complete the Job. This SAPBW LOAD PACK is the Bottle Neck...

Currently with 700 records per second , the job is taking 2.5 hrs to complete.
could you tell me as to how could i increase the reading speed to 7000 records per second.?

Hi all, I have developed a server Job in which i am reading Data from a Oracle Database and then through Transformer puts the DAta Into SAPBW LOAD PACK. Currently when i increased the Array Size to 2000 the reading speed is 700 records per second. IS there any way i can increase this speed to 7000 r...

The Job is reading data from Oracle Database in a parallel Job and its speed is 600 rows per second.
Can anyone tell me as to should i increase the number of records read per minute.
and how should i increase the number of nodes in parallel Job.

Thanks
Ashish Gupta
+919922892057