What is a diff between joiner and lookup transformation
Answer Posted / kittu
hi every one
i read all the answers i agree with you but one more thing is there in joiner. once u specify d joiner it will extract all the data from source and check the based on condition then it returns values.
in look up it wont take any values but it refers based on condition.It means look up check the values present r not.
here main thing is memory if cache size is increase it decrease the informatica performance.same thing will happen in joiner trans so mostly we r not using joiner but some times based on source data we use.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the mapping variable usage example in informatica
How to use pmcmd utility command?
What are the different types of olap? Give an example?
What is the need of etl tools?
what is the -ve test case in your project.
Implementation methodology
What is the different lookup cache(s)?
How can you increase the performance in joiner transformation?
How can we improve session performance in aggregator transformation?
Describe an informatica powercenter?
What is sequence generator transformation in informatica?
What could be the possible resons of locks by user?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What does “tail –f” command do and what is its use as an Informatica admin.
what is the difference between informatica6.1 and infomatica7.1