Can anyone tell me the new features in Informatica 9 Version?
Answer Posted / chandra sekhar
1. lookup can be configured as active transformation
2. We can write SQl override on the uncached lookup. Earlier
we can do this only on cached lookup.
3. We can increase the size of the Session log file.
4. **** Database resilience feature: If the session overcome
a database dead lock it will not fail the session
immediately it will retry again and we can configure the no
of times we wanted the integration service to retry.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Implementation methodology
Describe an informatica powercenter?
Make a note of the quantity vaults made in informatica?
What is informatica metadata and where is it stored?
What is the difference between router and filter?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is decode in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
What is a surrogate key?
What are the types of caches in lookup? Explain them.
How are the sources and targets definitions imported in informatica designer?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is the surrogate key?
What is the use of source qualifier?