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
- 22873 Views
- I also Faced
- E-Mail Answers
Answer Posted / vivek
as per my understanding.. lkp is always behave like left
outer join..it ll give you all matched records as well as
ummatched records which is not present in base table...and
those unmatched records is ll be null in case of
unconnected lkp trn.....
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is a node in Informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How can we use mapping variables in informatica? Where do we use them?
What is a difference between complete, stop and abort?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What do mean by local and global repository?
What is the reusable transformation?
What is the sql query overwrite in source qualifier in informatica
What could be the possible resons of locks by user?
Why union transformation is an active transformation?
what is informatica metadata?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is target load order?
What is a pre-defined event and user-defined event?
How to do unit testing in informatica?
