Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 6 Answers
- 22874 Views
- I also Faced
- E-Mail Answers
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 are the conditions needed to improve the performance of informatica aggregator transformation?
Differences between connected and unconnected lookup?
What is primary and backup node?
How to extract the informatica rejected data?
What is pmcmd command?
What is the commit type if you have a transaction control transformation in the mapping?
What is the sequence generator transformation in informatica?
How union transformation is used?
How do you load only null records into target? Explain through mapping flow.
How to do unit testing in informatica?
Explain what is informatica metadata and where is it stored?
Where is metadata stored?
What are session parameters ? How do you set them?
What are the tasks that source qualifier perform?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
