Answer Posted / vas.chiky
for complex results, which we cannot obtain in SQL or from
informatica transformation, we go for procedures.
Also doing the calculation in database level doesnt makes
work load high for our informatica server.
process will be given to database.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the new features of informatica 9.x at the developer level?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to delete duplicate row using informatica?
What are the limitations of joiner transformation?
Explain the different dimensions.
In warehouses how many schemas are there?
Explain dynamic target flat file name generation in informatica
What is data movement mode in Informatica and difference between them?
How to open an older version of an object in the workspace?
What is flashback table ? Advance thanks
How are the sources and targets definitions imported in informatica designer?
Is it possible to use a client with different version than that of its Informatica server?
What is mapping debugger?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the different ways to implement parallel processing in informatica?