tSCDELTJDBC Component for Snowflake

[Ani1]

Hi,

I am trying to implement an SCD Type-2 functionality below are the details:
1) source and target tables are on AWS cloud Snowflake

2) using Talend studio 7.2 cloud enterprise edition

3) Using tSCDELTJDBC component

Issue:

While implementing SCD type-2 using the dates method,

1) New Insert End_Date should be '31-12-9999 00:00:00' instead of null

2) End_Date for updated records to be 'current_timestamp -1 sec', instead of just 'current_timestamp'

I need help in implementing the above. A big Thank You!! in advance for helping me solve this issue