Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95250 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / chandra
Joiner will join the two different data sources based on a
join condition ,and pass only the rows which satisfy that
condition.discards the remaining rows.
Joiner transformation supports 4 types of joins at
Informatica level
Normal
Master Outer
Detail Outer
Full Outer
LookUp Transformation
Lookup transformation basically for Reference,based on the
lookup condition.when u want some data based on target
data ,will take lookup on that particular table and
retrieve the corresponding fields from that table.
we can override the lookup transformation using the SQL
query.
| Is This Answer Correct ? | 72 Yes | 19 No |
Post New Answer View All Answers
What differs when we choose the sorted input for aggregator transformation?
How might you approve all mappings in the archive all the while?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
can we override a native sql query within informatica? Where do we do it?
Differentiate between Load Manager and DTM?
What is olap (on-line analytical processing?
Explain incremental aggregation in informatica
What is status code in informatica?
In informatics server which files are created during the session rums?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Can you use flat files in Mapplets.
What is the meaning of decode in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the different types of olap? Give an example?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
