What is a diff between joiner and lookup transformation
- 16 Answers
- 92874 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / mythili
Hi everybody,
Joiner is active transformation whereas lookup is passive
transformation.
Joiner returns only matching records whereas lookup
returns null if there is no match.
In join condition we can give only '=' operator but in
lookup condition !=,>=,<= are all possible.
Joiner will do left outer,right outer,normal,full outer
type of joins whereas lookup will do only left outer join.
| Is This Answer Correct ? | 31 Yes | 9 No |
Post New Answer View All Answers
EXL informatica Questions
Explain in detail scd type 2 through mapping.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is a pre-defined event and user-defined event?
explan ur project architecture?
What is the surrogate key?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain what is informatica metadata and where is it stored?
To import the flat file definition into the designer where should the flat file be placed?
What are the types of schemas we have in data warehouse and what are the difference between them?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Differentiate between source qualifier and filter transformation?
How an expression transformation differs from aggregator transformation?
What is a sorter transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
