Interested to Buy Any Domain ? << Click Here >> for more details...
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
- 4 Answers
- 21479 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / krishna
joiner is best because we will make less number of records or dublicate records as master. integration servic create cahce for master table. becaue of that cahce size is small and secarching oricess become easy. in case of lookup its should scane om botom to end it will take more time.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a dimensional model?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How do you convert single row from source into three rows into target?
What are the new features of informatica 9.x at the developer level?
Why union transformation is an active transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is the use of transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are the different lookup cache(s)?
What is union transformation?
What does role playing dimension mean?
What are the mapping parameters and mapping variables?
tell me 5 session failure in real time how can you solve that in your project?
What is union transformation in informatica?
generate date / time dimension in informatica
