Briefly explain the aggregator transformation?
What are the issues you have faced in your project? How did you overcome those issues?
What is domain in terms of informatica?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
update strategy transformation in informatica
What differs when we choose the sorted input for aggregator transformation?
whats the logic to load the lower level of granularity of data to fact table.
What is dimensional table? Explain the different dimensions.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How are indexes created after completing the load process?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
what is Active lock explain
What is the function of union transformation?
What is informatica? Why do we need it?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.