LOOKUP Condition is nothing but a Join condition?
What type of join condition it,by default ?
Using the LookUP Condition How many types of relational
conditions we can make ?
Answer Posted / krishna
lkp is passive tr beacuse it returns 0 when condition doesn't matches .
If multiple conditions match in lkp returns first & last values.
Lkp supports Equi & non-Equi joins.
By default it is left outer join.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is meant by a domain?
What is session task and command task?
What is a node in Informatica?
In informatics server which files are created during the session rums?
list out all the transformations which use cache?
What does role playing dimension mean?
Different qualification between a related rotate toward the sky and isolates look upward?
What are active transformations.
What is incremental aggregation?
can anyone suggest best free Talend data integration training online
Tell me about Propagate functions in informatica
Target increases every day even though no new record was inserted
What are the performance considerations when working with aggregator transformation?
What are the main features of Oracle 8i with context to datawarehouse?