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
- 21065 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 prerequisite tasks to achieve the session partition?
What is meant by incremental aggregation?
Implementation methodology
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Separate from an archive server and a powerhouse?
What is informatica? Why do we need it?
How union transformation is used?
What is rank index in rank transformation?
What is the surrogate key?
What is pmcmd command?
expain about the tune parameters?
What is joiner transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Can we create a Integration service without a Repository service and vice versa?
Design a mapping to load the cumulative sum of salaries of employees into target table?
