Skip to Content
Author's profile photo Former Member

How to update Target table without using TABLE_COMPARISON transform.

Hi All,I want to update product few columns data (i.e PROD_TYPE,PROD_MFD) in my target table PRODUCT. I have implemented Job using SCD type1 but performance reasons my team not supporting this process. Kindly help on this issue to get resolve.

Target table (PRODUCT) has 3 million records.



Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Dear Srinivas,

      What type of option you are using in your table comparison. ROW-by-row select or chached comparison or sorted input.

      Also for SCD type 1 we can go for Auto correct load but, if your target count is less means than the autocorrect load will work if the target count is more than again the performance issue will come.

      As your target table having 3 million records. so, auto correct load won't be the better option.