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
- 21069 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 do you mean by DTM and Load manager and what is difference between load manager and load balancer?
On which transformations you created partitions in your project?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What are some examples of informatica etl programs?
What are data-driven sessions?
Explain sessions and how many types of sessions are there?
Explain the scenario which compels informatica server to reject files?
Briefly define a session task?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
how tokens will generate?
What are the modules in Power Center
Why do you use Mapping Parameter and mapping variable?
How can you define user defied event?
What is a snowflake schema?
