Wednesday 6 May 2015

Soft Delete logic in ODI in Biapps 11g(11.1.1.8.1)

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

No comments:

Post a Comment