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
- 6670 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 |
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
what are the different Reporting and ETL tools available in the market?
what are business components in Informatica?
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000
what are Lookup caches options? Including persistent caches.
how do u really know that paging to disk is happening while u are using a lookup transform?
What is data cleaning?
what is the difference steps for data modeling?
What is the main difference between peek stage and copy stage
what is Forward,Reverse and Re_engineering?
Teradata 
