Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff joiner and lookup
- 4 Answers
- 8494 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suresh
lookupT/r is passive tranforamtion where as joiner is active t/r
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / padmavathi
Joiner:
Can join herterogeneous sources.
Can join non-relational sources.
Can join partially transformed data.
Loopup:
Can reuse cache across session run.
Can reuse cache with mapping.
Can modify cache dynamically
Can query relational table or flat file.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / akhil4
joiner:
1.joiner is active tr.
2. with joiner tr u can not perform noneqi join.
lookup:
1.lookup is a passive tr
2.with joiner tr u can perform noneqi join.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / r.venkata srinivas
The differences between Joiner T/R and Lookup T/R are
mentioned in the following
Joiner Transformation:
1.Joiner is a Active Transformation.
2.It supports left & right outer join
3.Joiner Transformation is not support OR condition
Lookup Transformation:
1.This is a Passive transformation.
2.It does not support Left & Right outer join.
3.Lookup transformation supports Lookup Override.
| Is This Answer Correct ? | 1 Yes | 2 No |
server hot-ws270 is connect to Repository B. What does it mean?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
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 a surrogate key?Why we use it in a mapping?Pl give an example.
How to create the source and target database connections in server manager?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
what is parameter file?
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
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?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
Teradata 
