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.

Regards,

Srinivas

To report this post you need to login first.

1 Comment

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

  1. prasanna na

    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.

    Regards,

    Prasna

    (0) 

Leave a Reply