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


Please Help Members By Posting Answers For Below Questions

Implementation methodology

1264


Describe an informatica powercenter?

609


Make a note of the quantity vaults made in informatica?

561


What is informatica metadata and where is it stored?

591


What is the difference between router and filter?

651






Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1624


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

606


What is decode in informatica?

659


What are the issues you have faced in your project? How did you overcome those issues?

1916


What is a surrogate key?

563


What are the types of caches in lookup? Explain them.

553


How are the sources and targets definitions imported in informatica designer?

672


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 .

1473


What is the surrogate key?

644


What is the use of source qualifier?

675