Explain the shared cache and re-cache?
How do you promote a non-reusable transformation to reusable transformation?
How the Informatica Server reads perameter file?
What all are steps in up gradation of Informatica server?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
How to load time dimension?
Useful UNIX commands regular/frequently used
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
How the informatica server sorts the string values in Rank transformation?
HOW DO YOU CONNECT TO REMOTE SERVER ?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
Diffrence between 7.1,8.1 and 8.6
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...