Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answers were Sorted based on User's Feedback



1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ..

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

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ..

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

Post New Answer

More ETL Interview Questions

Eliminating of duplicate records without using dynamic lookups

4 Answers   IBM,


What are various etl tools in the market?

0 Answers  


how would u estimate the size of Lookup transform data and index cache?

0 Answers  


How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?

2 Answers  


what is granularity in Data ware House?

0 Answers   IBM,


what is the difference between cardinality and Nullability?

0 Answers  


what are the data modeling tools you have used?(polaris)

0 Answers  


dimension object created in oracle can be imported in designer?how?

0 Answers  


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

1 Answers  


how would u estimate the size of Lookup transform data and index cache?

1 Answers  


What is a staging area? What is the purpose of a staging area?

0 Answers  


What is etl process? How many steps etl contains?

0 Answers  


Categories