Can anyone tell me the new features in Informatica 9 Version?
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 |
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
What is a filter transformation and why it is an active one?
what are the types of Data warehousing ?
What is the difference between lookup override and souce qualifier override ?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
What is the meaning of decode in informatica?
tell me 5 session failure in real time how can you solve that in your project?
In joiner, how to load Master table in Target?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
checkout and checkin in informatica 8.6
What is the difference between Bulk Load and Normal Load
What are the challenges of Dataware housing in the future?