what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).
- 3 Answers
- 9326 Views
- IBM, ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / akash
In addition to Kondeti's points:
1. With look up we have an option to match the data
dynamically if we use dynamic lookup.
2. If the match is not found may or may not send the record
(depending upon the joiner condition) but in case of look
up the output will be returned as default value or NULL for
every record where match is not found.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the static cache and dynamic cache in informatica?
can anyone suggest best free Talend data integration training online
whats the logic to load the lower level of granularity of data to fact table.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to generate sequence numbers using expression transformation?
What is lookup change?
What are session parameters ? How do you set them?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is a grid in Informatica?
How can you increase the performance in joiner transformation?
What is the benefit of partitioning a session?
What are the differences between source qualifier and joiner transformation?
can anyone explain me about retail domain project in informatica?
