Hi,
We recently upgraded our application from 3.2 to 4.2 SP11.
Upgrade was smooth. Almost all the jobs are successfully migrated to new sever and also working fine.
Source is ECC 6.0
Target is SQL DB 2005.
After upgrade I came across a scenario where dataflow is taking around 4 hours of time to complete in new environment which used to take only few seconds in old environment.
Dataflow is very simple. It is updating only four fields with maximum 50 rows from multiple source tables based on join condition, however the data volume in source table is huge.
Please find following source table information,
SWW_WI2OBJ : Data Volume: 20,958,867
SWWUSERWI : Data Volume: 592,021
SWWWIHEAD : Data Volume: 22,914,257
Please find following DF design.

Query Transform definition.

What I noticed from Job performance monitor log is,
In the new environment, first it is pulling all the records from source tables and then applying join however on the old system it is only fetching required records based on join condition from source itself.
May be I am wrong so,I am attaching job monitor log from both environments for reference.
Please let me know incase require more information.
Thanks,
Darshil Shah
monitor-log-from-old-environment.pngmonitor-log-from-new-environment.png