Interested to Buy Any Domain ? << Click Here >> for more details...
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
- 1 Answers
- 5197 Views
- IBM, I also Faced
- E-Mail Answers
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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What do you mean by enterprise data warehousing?
How to extract sap data using informatica? What is abap? What are idocs?
wat are deployement groups in informatica, how it will be used for developers
difference between informatica 8.1.1 and 8.6
Differentiate between sessions and batches?
Tell me about MD5 functions in informatica
What is data transformation manager process?
Why is sorter an active transformation?
What is a dimensional model?
What is update strategy transform?
What is a difference between complete, stop and abort?
What are multi-group transformations?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
