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 / srinu
Hi Kalyan ,,Thanks,,
Lookup Trans is a Passive,
It wil return all source rows,Match or Unmatch,,,
Source column Checks with LookupCache column , wright ?
Return port may be Value or null.
Normaljoin wil Returns all Match rows only.
May be your Answer not Correct.
If any corrections 'srinu.srinuvas@gmail.com'
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What are different types of transformations available in informatica?
Informatica settings are available in which file?
Partition, what happens if the specified key range is shorter and longer
tell me the rules and responsblites in our project(my project is development)
What are the prerequisite tasks to achieve the session partition?
What is Cognos script editor?
How do you change a non-reusable transformation to reusable transformation?
Different circumstance which drives informatica server to expel records?
Where are the source flat files kept before running the session?
what is SDLC way of code development?
How do you load only null records into target? Explain through mapping flow.
Differences between version 7.x and 8.x.
Explain sessions and how many types of sessions are there?
Write the unconnected lookup syntax?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?