What is a diff between joiner and lookup transformation
- 16 Answers
- 92936 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
Plz can any one say me how to get the informatica certification materials and dumps
How do you promote a non-reusable transformation to reusable transformation?
Can we create two repositories on same database instance in oracle?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Under which circumstances, informatica server creates reject files?
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 ?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How to extract sap data using informatica? What is abap? What are idocs?
How might one distinguish in the case of mapping is right or not without associating session?
How to differentiate between the active and passive transformations?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is mapplet in informatica?
What is lookup transformation?
What are the types of caches in lookup? Explain them.
