Soft delete logic in ODI
----------------------------------------
RUN_REPLICATED_TRANSACTIONAL('#IS_SDS_DEPLOYED',
'N',
CASE WHEN F0101.CDC$_DML_CODE = 'D' THEN 'Y' ELSE 'N' END
)
this will work like below.
if IS_SDS_DEPLOYED is Y then below case statement will execute else value will be 'N'
CASE WHEN F0101.CDC$_DML_CODE = 'D' THEN 'Y' ELSE 'N' END
----------------------------------------
RUN_REPLICATED_TRANSACTIONAL('#IS_SDS_DEPLOYED',
'N',
CASE WHEN F0101.CDC$_DML_CODE = 'D' THEN 'Y' ELSE 'N' END
)
this will work like below.
if IS_SDS_DEPLOYED is Y then below case statement will execute else value will be 'N'
CASE WHEN F0101.CDC$_DML_CODE = 'D' THEN 'Y' ELSE 'N' END
No comments:
Post a Comment