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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply