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?
Define update strategy?
How to load last 10 records of flat file in to the target?
What is active and passive transformation?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
Do you have to change the reject file b4 using reject loader utility.
Is informatica power center designer has 64 bit support?
What is difference between a connected look up and unconnected look up?
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
Can we update a target table (without primarykey) by using update strategy transformation?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,