in which situations we go for pesistent cache in lookup and
which situations go for shared lookup cache?
Answers were Sorted based on User's Feedback
Answer / naga
If the lookup does not change between sessions, you can
configure the transformation to use a persistent lookup
cache. When you run the session, the Integration Service
rebuilds the persistent cache if any cache file is missing
or invalid.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sbvp
1.persistent is session level. it increase the perfomance.
it is useful for mutliple session runs.
2.if we want to lookup on mutli t/r's we go for shared
lookup
thanks
sbvp
Is This Answer Correct ? | 0 Yes | 0 No |
what are the different types of transformation available in informatica and what are the mostly used ?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
What is meant by LDAP users?
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
How the dimensions will be loaded?
draw informatica architecture 8.6 ?
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
can v update d records in target using update stargey without generationg primary key ? explain
While importing the relational source definition from the database, what are the metadata of source that will be imported?
To provide support for Mainframes source data,which files r used as a COBOL files
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How to list Top 10 salary, without using Rank Transmission?