SnapLogic - Integration Nation

Hi, I have requirement to perform lookup or left outer join on less than equal too column date datatype column. Note : i already tried using oracle execute but oracle execute performance not good because of back pressure. can help me to find out alte...

Facing failed to perform join operation

how to write below expression in snaplogic least( IIF(ISNULL(LINEAR_PREMR_DATE),to_Date(‘01/01/4000’,‘mm/dd/yyyy’),LINEAR_PREMR_DATE), IIF(ISNULL(GO_PREMR_DATE),to_Date(‘01/01/4000’,‘mm/dd/yyyy’),GO_PREMR_DATE), IIF(ISNULL(VOD_PREMR_DATE),to_Date(‘01...

How to call oracle function in snaplogic

I have one scenario for checking file on s3 bucket if file available then process it else send email file not present on bucket.