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
- 9921 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 |
AT the max how many transformations and mapplets can we use in a mapping ?
1 Answers Cap Gemini, Cognizant,
Sequence generator, when you move from develoment to production how will you reset
What is data transformation manager process?
Explain load alternative records / rows into multiple targets - informatica
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
what is parameter file?
which transformation uses cache?
what is confirmed dimension?
Is there any model difference between ODS and DWH
What are the different options available for update strategy?
Howmany ways yoU can update a relational source defintion and what are they?
In ur current projectu have done any performance tuning of mappings?
Teradata 
