Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).
- 3 Answers
- 10267 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
what are 3 tech challenges/ common issues you face?
What is target load order?
What is the difference between router and filter?
What is the difference between a connected look up and unconnected lookup?
Why update strategy and union transformations are active?
What are the main issues while working with flat files as source and as targets ?
What is a joiner transformation?
In development project what is the process to follow for an etl developer from day1
If informatica has its scheduler why using third party scheduler?
What is depict expression change?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Define sessions in informatica etl?
How many transformations can be used in mapplets.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
