Skip to Content

SQL Transform & Table Join — Performance Issue

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

Be the first to leave a comment
You must be Logged on to comment or reply to a post.