Skip to Content
Author's profile photo Former Member

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

Assigned tags

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