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...

Difference in the implementation of lookup and join
stages,in joining two tables?

Answer Posted / anburadh

one more point to add on MERGE and LOOKUP
Merge can not allow duplicate records whereas LOOKUP will allow or can control duplicates using OPTION"MULTIPLE ROWS ON THE LINK" which is in constraint TAB.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between data warehousing and olap?

1097


Distinguish between informatica & datastage. Which one would you choose and why?

1011


what is the custome stage in datastage? how can we impliment that one? plz tell me

2370


How will you move hashed file from one location to another location?

2156


Explain the datastage parallel extender (px) or enterprise edition (ee)?

1234


What is the difference between passive stage and active stage?

1543


What is the difference between in process and inter process?

1158


What are the enhancements made in datastage 7.5 compare with 7.0?

1150


What a datastage macro?

1065


Explain connectivity between datastage with datasources?

986


Can we use target hash file as a lookup ?

3328


What are the different kinds of views available in a datastage director?

1033


What is data partitioning?

1212


Have you used Unstructured data?

1326


how to sort two columns in single job in datastage.

2907