Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / maruthi

union-can join two tables without common port
joiner-can join any two hetrogenous sources,but common port
is necessary.
lookup-we can join two tables by using sql over-ride,apart
from that we can check wether the row is already existing
or not.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the impact of several join conditions and join order in a joiner transformation?

1115


Is there any way to read the ms excel datas directly into informatica?

1070


Design a mapping to load the cumulative sum of salaries of employees into target table?

1557


What are active and passive transformations?

1134


what is the size ur source like(file system or database)? how many record daily come u r banking project?

2193


Explain target update override in informatica

1190


list out all the transformations which use cache?

1242


What are the modules in Power Center

1720


How does the aggregator transformation handle null values?

1197


What is the fact table?

1140


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7588


How does a sorter cache works?

1110


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1200


How can you validate all mappings in the repository simultaneously?

1427


wf dont have integration severances how you can run?

1988