difference between lookup, join and merge in datastage

prematram · Post by **prematram** » Wed Dec 19, 2007 5:55 am

Hi,
What is the difference between lookup, join and merge in datastage...??...which is more efficient....??

divine · Post by **divine** » Wed Dec 19, 2007 9:01 am

Hi
Please try the search option for such kind of Queries.

If you do not find something useful then i think you do have manuals (PDF) with Datastage installation. Go and find in "PARALLEL JOB DEVELOPER GUIDE".

After doing all above mentioned things Still you are in Confusion then raise a query in DSXchange

ray.wurlod · Post by **ray.wurlod** » Wed Dec 19, 2007 4:04 pm

Define "efficient" in this context. Each stage performs a different tasks - that's why more than one stage type exists.

Is this an interview question?