Can anyone tell me the new features in Informatica 9 Version?
- 2 Answers
- 7035 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / praveenabhaskar
We can integrate the data in cloud applications, as well as
we can run Informatica 9 on cloud infrastructure and
Informatica Analyst is the new tool introduced.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
which is better perfomancewise lookup or joiner and why?can anyone give example?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
what is confirmed dimension?
Explain pmcmd command usage in informatica
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
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
Explain dynamic target flat file name generation in informatica
What is the advantage of persistent cache? When it should be used.
What is lookup transformation?
Target is zero file and how can you send the email?
if soource is having 10 records how will u insert 20 records to target
Teradata 
