Interested to Buy Any Domain ? << Click Here >> for more details...
1. if lookup tr is giving poor performamence. what u do.
2. i have emp,dept table. i want output
ename,empno,dname,max(sal).
3. can any one tell me project flow in real time scenario.
please send me mail any queries and answers
my mail id is yaparala@gmail.com
- 2 Answers
- 6809 Views
- HCL, iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / reddy guru
According to my knowledge write a query inlookup query
override or increase the cache size
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sandhya
Hi,
i dont know wether this is write or wrong .but in my way in look up we r having 2 modes cache &noncachemode noncache mode is low performance than the cachemode .bcz look up will maintains the connection with lookup table until comparision is completed.in cache mode lookup table data loaded into memory &dis connected from the lookup table this gives high performance
by using joins we can get the results as of my knowledge
| Is This Answer Correct ? | 0 Yes | 4 No |
What is Data Vault???
When do we analyze the tables? How do we do it?
what is meant by drill through?(Mascot)
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
Is hadoop a etl tool?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
how would u estimate the size of Lookup transform data and index cache?
Identifying the bottlenecks in various components of Informatica and resolving them.
What are snapshots?
what is the difference between cubes and package in cognos
Explain what are the various etl tools in the market?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
Teradata 
