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
- 22888 Views
- I also Faced
- E-Mail Answers
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
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the Rank index port in Rank transformation?
How do you convert single row from source into three rows into target?
What are session parameters ? How do you set them?
What is source qualifier transformation in informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
What is the different lookup cache(s)?
What is the need for an etl tool?
Explain load alternative records / rows into multiple targets - informatica
Explain your project of banking domian.
What is native users?
What is data transformation manager process?
what is SDLC way of code development?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the types of caches in lookup? Explain them.
