Rahulsingh
New Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
How to perform lookup or left outer join on less than equal operator
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 alternative to achieve same logic or how to increase Oracle execute performance1.7KViews0likes0CommentsRe: Expression in mapper
Date.parse(Date.parse(Math.min(($MAX_LINEAR_PREMR_DATE == null ? 64060588800000 : Date.parse($MAX_LINEAR_PREMR_DATE).getTime()),($MAX_GO_PREMR_DATE == null ? 64060588800000 : Date.parse($MAX_GO_PREMR_DATE).getTime()),($MAX_VOD_PREMR_DATE == null ? 64060588800000 : Date.parse($MAX_VOD_PREMR_DATE).getTime()))).toString()).toLocaleDateTimeString({“format”:“MM/dd/yyyy hh:mm:ss aa”})2.3KViews0likes6CommentsExpression in mapper
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/01/4000’,‘mm/dd/yyyy’),VOD_PREMR_DATE))5.4KViews0likes9Comments