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
- 10115 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 to get EVEN & ODD numbers separately?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
why we r using presql&postsql in source qualifier?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
How would you join a node to the already existing domain?
What are the different types of olap? Give an example?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Different qualification between a related rotate toward the sky and isolates look upward?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
Different types of Power center errors?
Teradata 
