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 meant by a domain?
How to do unit testing in informatica?
What is powercenter on grid?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Different circumstance which drives informatica server to expel records?
Differentiate between source qualifier and filter transformation?
What are the modules in Power Center
Define update strategy?
What is meant by incremental aggregation?
What is substr in informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Whats the difference between informatica powercenter server, repositoryserver and repository?
How can we handle two sessions in informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions