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
Mention a few design and development best practices for informatica?
What are the types of data warehouses?
Explain sessions. Explain how batches are used to combine executions?
What are roles and groups and benefits of using them?
Could you explain what is enterprise data warehouse?
Where do we use mapping variables in informatica?
whats the logic to load the lower level of granularity of data to fact table.
How can we update a record in the target table without using update strategy?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
what is SDLC way of code development?
what is size of u r database?
How to call shell scripts from informatica?
What is dimensional table? Explain the different dimensions.
Explain the pipeline partition with real time example?
As union transformation gives UNION ALL output, how you will get the UNION output?