what is the diff b/w union and joiner and lookup?

Answer Posted / rajesh myle

1. Lookup T/R supports Non-Equi Joins. Where as Joiner
T/R does not support the Non Equi Joins. (Joiner T/R
supports only Equi Joins(i.e. ‘=’))

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Different sorts of metadata that stores in the storage facility?

559


Whats the difference between informatica powercenter server, repositoryserver and repository?

673


How can we delete duplicate rows from flat files?

741


What is confirmed fact in dataware housing?

5684


How will the document be delivered to me?

617






can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10278


What is the meaning of up gradation of repository?

1387


Define mapping and session?

585


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1754


What if the source is a flat-file?

590


How to elaborate powercenter integration service?

648


What is meant by a domain?

630


How do you remove duplicate records in informatica? And how many ways are there to do it?

713


What are the guidelines to be followed while using union transformation?

639


What are ETL Tools?

666