Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff joiner and lookup
- 4 Answers
- 8640 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 |
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
What is tracing level and what are the types of tracing level?
Explain the mapping variable usage example in informatica
What is the maplet?
Explain load alternative records / rows into multiple targets - informatica
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
Enlist few areas or real-time situations where informatica is required.
how to improve performence by using sorted input in aggrigator t/r.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain in detail scd type 2 through mapping.
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
with out using update strategy transnsformation how to update the data in mapping level
Teradata 
