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 / venkat
here lkp transformation is perform left outer join only.
it will display matching and non matching records,but in
case of non matching(while using conn lkp)records return
default value.while using unconn lkp returns null value.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is olap (on-line analytical processing?
can u any challenge your project?
Explain the different lookup methods used in informatica?
How to create a non-reusable instance of reusable transformations?
What is parallel processing in informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is meant by target load plan?
What is session task and command task?
Mention few advantages of router transformation over filter transformation.
As union transformation gives UNION ALL output, how you will get the UNION output?
How to open an older version of an object in the workspace?
What do you mean by worklet?
How to generate sequence numbers without using the sequence generator transformation?
What does cheating measurement mean?