BODS 3.2 SQL transform with bulk load API takes forever

[Smarty]

I have a data flow that has sql transform with bulk load API, however this DF takes forever to load 300k records. The monitor log says status READY after 10 hours it loads data fine. I have checked Data service performance monitor and data base sql/session monitor there is nothing unusual.

Please let me know what might be causing this issue?


/thanks

Smarty

[eganjp]

How many rows are there already in the target table?

Are you sure that it is the target table that is the problem? To rule out the target table put a map_operation before the target table and discard all operation types.

[amuh10]

If the Monitor log says READY, that means the SQL is seems push down to the SQL level. So my understanding is that you have a issue with your joins, as 300k records should not 10 hours to load.