Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff joiner and lookup
- 4 Answers
- 8470 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 TO GET THE LATEST DATA IN SCD ?
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
what is the significance of newlookup port in dynamic look up
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
what is the diff b/w cached and unchaed look ups
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
How can informatica be used for an organization?
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
What is the difference between informatica 7.0 and 8.0?
where does the default group roew in a router is stored what is the default size of memory in router
Filter transformation in the condition one of the data is NULL would the record be dropped.
Teradata 
