SnapLogic - Integration Nation

Its Failed only in that condition if row data count exceeds more than 20 lac other its back status as completed.

$DATEKEY== 20230301 ITS DYNAMIC. SQL Statement select CAST(TO_CHAR(TRUNC(CAST(SYSTIMESTAMP AT TIME ZONE ‘Asia/Calcutta’ AS DATE)-20, ‘mm’), ‘YYYYMMDD’) AS int) as DATEKEY from dual