Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95950 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
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 dynamic target flat file name generation in informatica
Why filter transformation is an active one?
Can we override a native sql query within informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
difference between repository database and repository service?
How to use pmcmd utility command?
How to improve the performance of a session using sorter transformation?
Briefly define reusable transformation?
What is native users?
where to store informatica rejected data?
Explain incremental aggregation in informatica
What is workflow manager?
What are connected or unconnected transformations?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
