How to connect to flat file source which are in server system?

How to load the data in different targets in parallelly?Assume 3 targets are there 1st one should load first and 3rd one should load 2nd and 2nd one should load 3rd with in the same mapping?

I want to know what are the steps to be followed to create a employee datawarehouse.What actions needs to be performed.

How to create cube using Oracle Database in Informatica? Give example.

How to copy ports from source table into a transformation which is used in transformation developer?

What is a look up function? What is default transformation for the look up function?

What is a Mapplet?

What is DTM Session?

How to check data integrity in Informatica?

Why Union cannot use cache memory?

How can we migrate mappings and session from Informatica 6.2 to Informatica 7.1?

What is re_dimension?

What is the associated prt in Infromatica?

How to get pivot using expression transformation?

Explain how transformation scope effects joiner transformation?

What is the toughest query dealt in production support?

Outline different transformation scenarios.

How to create a new domain in Informatica PowerCenter Repository Manager? What is the Gateway Host and Gateway Port to create a new domain?

How to open project locks in Informatica?

How can we access the AEP (Advanced External Procedure) in Informatica8.1?