Informatica

[massmaharaj]

can we write a sql query in filter transformation or expression transformation

not isnull(primary_key) and (end_dt between (select max(end_dt) from schema.status_table where process ='update') and sysdate)

[massmaharaj]

help

[ganesh]

nope

[yankees]

source qualifier lo filter cheyyi not isnull(primary key) and then . then aggregate the end date with max(end_dte) and filter with end date process = update and then expresssion you can put the other logic which is between

[yankees]

pm cheyyi if you have any doubts

[pittakatha]

nope yankees ni follow kaaa....r else ping me as well.....