Push down optimization in Informatica cloud with Example | Performance tunning in Informatica |

[@nivruttidhakane8991]

Very well explained ❤

[@kirank-z6o]

In stored procedure transformation we use SQL query then how it reduce performance by using stored procedures in mapping

[@rahulmahendru103]

sir explane in iics who we use multiple left join in mapping task and
2) how we create the query as in IICS SELECT Source_table.ROW_ID, Source_table.FNCL_ACNT_ID, Source_table.EML_SBJCT_TX, Source_table.FRST_NM, Source_table.LST_NM, Source_table.TYP_DS
FROM
Source_table WHERE
Source_table.CRTD_TS >=(SELECT MAX(RUN_DT) FROM Target_table WHERE Target_table.TRGT_TBL_NM ='Source_table')
AND
Source_table.ROW_ID >(SELECT MAX(STRT_ROW_ID) FROM Target_table WHERE Target_table.TRGT_TBL_NM = 'Source_table') WITH UR