performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Answer Posted / venubyna1
Lookup is better as compare to join
bcoz joiner does not supports to inequality but look
supports to inequality
and both r does not support OR condition
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to partition the Session?
What are the designer tools for creating transformations?
Explain the informatica workflow?
How to handle decimal places while importing a flatfile into informatica?
How to generate sequence numbers using expression transformation?
Explain in detail about scd type 1 through mapping.
What is informatica metadata and where is it stored?
What are the types of schemas we have in data warehouse.
What is sorter transformation?
what is INFORMATICA TESTING process
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the meaning of up gradation of repository?
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 is a joiner transformation?
Why do you use Mapping Parameter and mapping variable?