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
Why do we need informatica?
How to extract sap data using informatica? What is abap? What are idocs?
How can you generate reports in informatica?
How can we use mapping variables in informatica? Where do we use them?
How you prepared reports for OLAP?
What is option by which we can run all the sessions in a batch simultaneously?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Different circumstance which drives informatica server to expel records?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is complex mapping?
Explain the difference between mapping parameter and mapping variable?
What does cheating measurement mean?
Write the advantages of partitioning a session?
What is update strategy transform?
To import the flat file definition into the designer where should the flat file be placed?