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 is lookup change?
What is the reusable transformation?
How to load a Dimension ? and how to load a fact table?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What do you understand by term role-playing dimension?
What all are steps in up gradation of Informatica server?
generate date / time dimension in informatica
What are the measure objects?
wat are deployement groups in informatica, how it will be used for developers
Whats the difference between informatica powercenter server, repositoryserver and repository?
Tell me about MD5 functions in informatica
Describe the impact of several join conditions and join order in a joiner transformation?
What are the different types of olap? Give an example?
How will the document be delivered to me?
Which transformation should we use to normalise the COBOL and relational sources?