Hello All,
Am facing an issue in one of my stage job in SAP BODS.
i have a stage job where i pull the data from source to stage. the source table is Oracle and stage is oracle table.
The mapping is just one to one. But, in source table count is almost 11 crore and the count is increasing day by day. so, our job is taking long time for execution almost 4hour. 30 minutes. Earlier the table extraction used to take 2:00 hours only.
It's really causing a lot of performance impact.
I tried the below options.
1)increased the array fetch size of the table and also increased the rows per commit but, no use
2)increased the array fetch size and then changed the bulkloader option to API and rows per commit but, no luck
3)tried with Degree of parallelism option but no luck
4)tried with the Dataflow pageagle cache to in-memory but, no luck
Can anyone of you please help me to resole this issue.
Source: Oracle
Target: oracle
Where cluase: Yes
Version: BODS 3.1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.