Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations we go for pesistent cache in lookup and
which situations go for shared lookup cache?
- 2 Answers
- 9925 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
How can we remove the duplicates from flat file source?
What is a connected transformation?
what is runtime variable?
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
What is a test load?
how i will stop my workflow after 10 errors
How to display First letter of Names in Caps?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Teradata 
