What is a diff between joiner and lookup transformation
- 16 Answers
- 92875 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
hi, everyone.
lookup is passive whereas is joiner is active.
look up supports non equi joins ilso whereas joiner
supports only equi joins.
lookup joins on either on first value or last value.
lookup uses dynamic and static cache where as a joiner
doesnt
reach me on bsrinivas1213@gmail.com
| Is This Answer Correct ? | 22 Yes | 11 No |
Post New Answer View All Answers
Explain the shared cache and re-cache?
Explain the use of aggregator cache file?
What do you understand by a term domain?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How to generate sequence numbers using expression transformation?
Explain informatica architecture - version 8 / 9
What is workflow monitor?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is sq transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How can we remove the duplicates from flat file source?
What are junk dimensions?
Mention a few design and development best practices for informatica?
Under what condition selecting sorted input in aggregator may fail the session?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
