SQL Transform & Table Join --- Performance Issue

[Former Member]

Hi All,

I am using SQL transform & B_PRODUCT table for Joining these two using left outer join and send required information into other TEMP_PROD table. After running the job SQL Transform & Table join step is taking long time, even I did not see full push down or Partial Push down kind of thing in Optimized SQL below statement only showing in Optimized SQL.

Please anybody help me to resolve this issue

In Display Optimized SQL :

SELECT "BU_CODE", "PRODUCT_CODE", "GLOBAL_H_CODE1", "GLOBAL_H_CODE2", "GLOBAL_H_CODE3", "GLOBAL_H_CODE4", "GLOBAL_H_DESC1", "GLOBAL_H_DESC2", "GLOBAL_H_DESC3", "GLOBAL_H_DESC4", "IB_BRAND_NAME", "ALL_PRODUCT_RANGE"

FROM "SYSTEM"."B_PRODUCT"

Regards,

Srini