I have a requirement to lookup the same table twice with different keys one after another. If the first lookup fails then only the second lookup should be done. And, i have to use connected lookup to return multiple output ports. Any idea how to do?

Informatica server is in Unix environment and other server is in Windows environment. I have to connect informatica server to other server .I am taking external procedure transformation in informatica to connect both servers.Is it possible to connect both servers by using Ext. Proc. Transformation?If it is possible , how to take DLL from other server to informatica external procedure transformation?

What condition should be specified in the Router transformation expression editor to get unique rows, duplicate rows and null values on a particular column in 3 different target databases?

I am using a flat file as source, my question is how can I know the end of file is reached? Is there any possibility to configure in session properties.

What I am trying to determine is if I could invoke a SAS session from within Informatica's ETL product(s) in order to execute a complicated transformation written in SAS which would then return the results to Informatica. We have a very complicated application written in SAS that we are evaluating as a candidate for conversion to Informatica.

I am getting this error "ORA-14050: invalid ALTER INDEX MODIFY PARTITION option" while running a procedure through informatica session. But the same procedure is executed successfully and doing the expected ,while executing in PL/SQL. The output of this proc comes like this ALTER INDEX MODIFY PARTITION < PARTITION_NAME> UNUSABLEIs there any specific syntax for executing alter index option through...