Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 96406 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
What is the procedure for creating independent data marts from informatica 7.1?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Is it possible to use a client with different version than that of its Informatica server?
Where do we use mapping variables in informatica?
What are the limitations of joiner transformation?
What is the scenario which compels informatica server to reject files?
Explain dynamic target flat file name generation in informatica
What is target load order?
expain about the tune parameters?
What are the advantages of using informatica as an etl tool over teradata?
What do you mean by worklet?
How we can create indexes after completing the load process?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Different qualification between a related rotate toward the sky and isolates look upward?
