What is a diff between joiner and lookup transformation
- 16 Answers
- 92869 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / jayash
joiner transformation does not match for null values where
as lookup transformation matches for null values
joiner transformation supports only equality operator in
condition of join where as lookup transformation can support
<=,>=,=,!= in the lookup condition
| Is This Answer Correct ? | 47 Yes | 8 No |
Post New Answer View All Answers
What is the different lookup cache(s)?
define galaxy repository in informatica
What are the types of caches in lookup?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Enlist the advantages of informatica.
Explain informatica architecture - version 8 / 9
What is the meaning of decode in informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How to load the data from people soft hrm to people soft erm using informatica?
Explain target update override in informatica
Explain pmcmd command usage in informatica
In how many ways we can create ports?
What are the various types of transformation?
What is the reusable transformation?
