What is a diff between joiner and lookup transformation
- 16 Answers
- 90943 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 does a rank transform differ from aggregator transform functions max and min?
What is mapplet in informatica?
What is deployment group?
Differentiate between a repository server and a powerhouse?
What are the types of data warehouses?
What is meant by lookup transformation? Explain the types of lookup transformation?
what is informatica metadata?
What are the different transaction levels available in transaction control transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is a code page?
What is a sequence generator transformation?
Whats there in global repository
How is union transformation utilized?
How to do unit testing in informatica? How to load data in informatica ?
What is complex mapping?
