What is a diff between joiner and lookup transformation
- 16 Answers
- 90990 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / prasanna
Joiner is active transformation in informatica to merge
nonsimilar structures into target warehouse systems.
Joiner needs a condiotion for data merging based on
following types
1.Normal join
2.Maste outer join
3.Detail outer join
4.Full outer join
Lookup is a passive transormation in informatica.this
transformation is used for data verfications of the source
table in assign lookup table
Lookup needs a condition if the condition is satisfied
returns corresponding data else returns null value.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How you prepared reports for OLAP?
What are the prerequisite tasks to achieve the session partition?
How many transformations can be used in mapplets.
Enterprise data warehouse your projects phase by phase explain?
What are the differences between joiner transformation and source qualifier transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How do we call shell scripts from informatica?
What is sequence generator transformation in informatica?
What is an active transformation?
Target increases every day even though no new record was inserted
How to join three sources using joiner? Explain though mapping flow.
what is informatica metadata?
update strategy transformation in informatica
Can we create a node as a gateway node and the same node can be assigned to a grid?
