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

What are the important features of datastage?

1121


Highlight the main features of datastage?

1157


What is a quality stage in datastage tool?

1071


What is ds designer?

1097


Explain connectivity between datastage with datasources?

972


How one source columns or rows to be loaded in to two different tables?

1126


What are stage variables, derivations and constants?

1218


What are the areas of application?

1145


Can you explain tagbatch restructure operator?

1171


What are constraints and derivations?

1166


Where the datastage stored his repository?

1084


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2252


Can you define merge?

1116


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3343


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2718