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
- 22688 Views
- I also Faced
- E-Mail Answers
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
What are the steps involved in the migration from older version to newer version of Informatica Server?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain target update override in informatica
Where are the source flat files kept before running the session?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How union transformation is used?
What is rank transformation?
How many number of sessions can one group in batches?
How to update a particular record in target with out running whole workflow?
How can we use batches?
Parameter and variable differences
What is workflow? What are the components of the workflow manager?
what is song in infrmatica...?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is rank index in rank transformation?
