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
- 6907 Views
- HCL, iGate, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
what is data modeling?
what is the use of server?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Explain about etl data integration software?
What are snapshots?
what is the difference steps for data modeling?
how do u really know that paging to disk is happening while u are using a lookup transform?
Two default user groups created in the repository are____and_____.
What is the difference between Data Warehousing and Data Mining?
what is different between sequential batch and concurrent batch and which is recommended and why?
When do we analyze the tables? How do we do it?
what is Forward,Reverse and Re_engineering?
What is tracing level?
