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
- 10034 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 |
comonly how meny mappings r there in Banking projects?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
what is target load plan
What is enterprise data warehousing?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is status code?
What is rank transformation?
can we load the data with out a primary key of a table? what is target plan?
Explain the different kinds of facts.
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
can we use mapplet as starting n ending object in mapping
Which transformation should we use to normalise the COBOL and relational sources?
Teradata 
