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
- 22664 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
How can we use mapping variables in informatica?
What are the different types of repositories created using informatica?
What is intricate mapping?
Can anyone tell me the new features in Informatica 9 Version?
What are mapplets?
What are batches?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is meant by query override?
Explian the Process of deployment groups in informatica
What is joiner transformation?
Where do we use mapping variables in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the meaning of decode in informatica?
What are the different transaction levels available in transaction control transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
