In pushdown optimization the Informatica Integration Service pushes the transformation logic to a database called active database and when it does not process then it is called idle database.
● When using full optimization in Informatica the target database will be active whereas the source database will be idle.
● In sessions which contain lookup transformation the source or target database is active whereas the lookup database will be idle.
● In sessions which contain joiner transformation in Informatica the source in the detail pipeline is active whereas the source in the master pipeline is idle.
● In a session which contains Union transformation the source in the first input group is active whereas the source in other input groups will be idle.
DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.