Informatica allows SQL to be executed in the source database and the results can be pulled by the PowerCenter.

By using SQL Override in Informatica, you can read only the required columns from the table instead of reading all columns from a table and can remove all unnecessary ports. You can also use customized logic in the SQL override.
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.