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 are different types of transformations available in informatica?
Explain the types of transformations?
What is a filter transformation and why it is an active one?
How would you join a node to the already existing domain?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Define mapplet?
What is target load order?
Differentiate between Load Manager and DTM?
Repository user profiles
What are the transformations that are not supported in mapplet?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
wat are deployement groups in informatica, how it will be used for developers
Design a mapping to load a target table with the following values from the above source?
How to generate sequence numbers using expression transformation?
Explain Dataware house architecture .how data flow from intial to end?