what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).
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
Is it possible to create multiple domains on a single Informatica server?
permutations of mapplet
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is a joiner transformation and why it is an active one?
can u any challenge your project?
Why union transformation is an active transformation?
What is rank index in rank transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
waht type of interface is used for testing the data in informatica
Differences between version 7.x and 8.x.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a router transformation?
What are the new features of Power Center 5.0?
how to load dimension table and fact table. plz tell me the steps.
How to Create a folder using pmrep command?