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
- 6913 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 |
Eliminating of duplicate records without using dynamic lookups
What are various etl tools in the market?
how would u estimate the size of Lookup transform data and index cache?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
what is granularity in Data ware House?
what is the difference between cardinality and Nullability?
what are the data modeling tools you have used?(polaris)
dimension object created in oracle can be imported in designer?how?
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
how would u estimate the size of Lookup transform data and index cache?
What is a staging area? What is the purpose of a staging area?
What is etl process? How many steps etl contains?
Teradata 
