What is difference between Merge stage and Join stage? - Merge and Join Stage Difference : 1. Merge Reject Links are there 2. can take Multiple Update links 3. If you used it for comparision , then first matching data will be the output . Because it uses the update links to extend the primary details which are coming from master link - DataStage Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATA WAREHOUSING

DATASTAGE

DETAILS

Question: What is difference between Merge stage and Join stage?

Answer: Merge and Join Stage Difference :

1. Merge Reject Links are there

2. can take Multiple Update links

3. If you used it for comparision , then first matching data will be the output .

Because it uses the update links to extend the primary details which are coming from master link

Category	DataStage Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 8396 users
Added on	7/26/2011
Views	69189
Rate it!

Question: What is difference between Merge stage and Join stage?

Answer:

Merge and Join Stage Difference :

1. Merge Reject Links are there

2. can take Multiple Update links

3. If you used it for comparision , then first matching data will be the output .

Because it uses the update links to extend the primary details which are coming from master link
Source: CoolInterview.com

while merge stage is being used the master link can't have duplicate values whereas the join stage has no such constraints. Source: CoolInterview.com

Answered by: Probal Banerjee | Date: 10/15/2009 |

Contact Probal Banerjee

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	How to implement type2 slowly changing dimenstion in datastage? give me with example?	View Answer
	How to find the number of rows in a sequential file?	View Answer
	Where actually the flat files store?what is the path?	View Answer
	What are the different types of lookups in datastage?	View Answer
	What are the most important aspects that a beginner must consider doin his first DS project ?	View Answer
	How we can call the routine in datastage job?explain with steps?	View Answer
	What is job control?how it is developed?explain with steps?	View Answer
	What is job control?how can it used explain with steps?	View Answer
	How to find errors in job sequence?	View Answer
	It is possible to access the same job two users at a time in datastage?	View Answer
	If the size of the Hash file exceeds 2GB..What happens? Does it overwrite the current rows?	View Answer
	How to drop the index befor loading data in target and how to rebuild it in data stage?	View Answer
	How to parametarise a field in a sequential file?I am using Datastage as ETL Tool,Sequential file as source.	View Answer
	How to kill the job in data stage?	View Answer
	Where we use link partitioner in data stage job?explain with example?	View Answer
	What is the difference between sequential file and a dataset? When to use the copy stage?	View Answer
	What is the purpose of exception activity in data stage 7.5?	View Answer
	How i create datastage Engine stop start script. Actually my idea is as below. !#bin/bash dsadm - user su - root password (encript) DSHOMEBIN=/Ascential/DataStage/home/dsadm/Ascential/DataStage/DSEngine/bin if check ps -ef \| grep DataStage (client connection is there) { kill -9 PID (client connection) } uv -admin - stop > dev/null uv -admin - start > dev/null verify process check the connection echo "Started properly"	View Answer
	What does separation option in static hash-file mean?	View Answer
	What is the difference between Symetrically parallel processing,Massively parallel processing?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All DataStage Interview Questions & Answers - Exam Mode / Learning Mode