What is a diff between joiner and lookup transformation
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 use of code page?
Write the different tools in the workflow manager?
update strategy transformation in informatica
Does an informatica transformation support only aggregate expressions?
Have you worked with/created Parameter file
What are the main issues while working with flat files as source and as targets ?
Explain sessions and how many types of sessions are there?
How would you copy the content of one repository to another repository?
can anyone explain me about retail domain project in informatica?
What are the main features of Oracle 8i with context to datawarehouse?
How can repository reports be accessed without sql or other transformations?
What is the difference between source qualifier transformations source filter to filter transformation?
What is informatica worklet?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is meant by target load plan?