What is merge ?and how to use merge? - Merge is a stage that is available in both parallel and server jobs. The merge stage is used to join two tables(server/parallel) or two tables/datasets(parallel). Merge requires that the master table/dataset and the update table/dataset to be sorted. Merge is performed on a key field, and the key field is mandatory in the master and update dataset/table. - 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 merge ?and how to use merge?

Answer: Merge is a stage that is available in both parallel and server jobs.

The merge stage is used to join two tables(server/parallel) or two tables/datasets(parallel). Merge requires that the master table/dataset and the update table/dataset to be sorted. Merge is performed on a key field, and the key field is mandatory in the master and update dataset/table.

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

Question: What is merge ?and how to use merge?

Answer:

Merge is a stage that is available in both parallel and server jobs.

The merge stage is used to join two tables(server/parallel) or two tables/datasets(parallel). Merge requires that the master table/dataset and the update table/dataset to be sorted. Merge is performed on a key field, and the key field is mandatory in the master and update dataset/table.
Source: CoolInterview.com

merge is used to merge the two tables, but when master and update records are merged only both have same merge key columns. Source: CoolInterview.com

Answered by: ashok madduri | Date: |

Contact ashok madduri

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
	What is difference between serverjobs & paraller jobs	View Answer
	How can ETL excel file to Datamart?	View Answer
	what is the mean of Try to have the constraints in the 'Selection' criteria of the jobs itself. This will eliminate the unnecessary records even getting in before joins are made?	View Answer
	What is the meaning of the following.. 1)If an input file has an excessive number of rows and can be split-up then use standard 2)logic to run jobs in parallel 3)Tuning should occur on a job-by-job basis. Use the power of DBMS.	View Answer
	How to implement routines in data stage,have any one has any material for data stage pl send to me	View Answer
	How can u implement slowly changed dimensions in datastage? explain? 2) can u join flat file and database in datastage?how?	View Answer
	How can you implement Complex Jobs in datastage	View Answer
	Does Enterprise Edition only add the parallel processing for better performance? Are any stages/transformations available in the enterprise edition only?	View Answer
	How can you do incremental load in datastage?	View Answer
	If your running 4 ways parallel and you have 10 stages on the canvas, how many processes does datastage create?	View Answer
	If data is partitioned in your job on key 1 and then you aggregate on key 2, what issues could arise?	View Answer
	What is the difference between Datastage and Datastage TX?	View Answer
	What are validations you perform after creating jobs in designer. What r the different type of errors u faced during loading and how u solve them	View Answer
	How can I specify a filter command for processing data while defining sequential file output data?	View Answer
	Can we use shared container as lookup in datastage server jobs?	View Answer
	Can any one tell me how to extract data from more than 1 hetrogenious Sources. mean, example 1 sequenal file, Sybase , Oracle in a singale Job.	View Answer
	What is the exact difference betwwen Join,Merge and Lookup Stage??	View Answer
	There are three different types of user-created stages available for PX. What are they? Which would you use? What are the disadvantage for using each type?	View Answer
	What user varibale activity when it used how it used !where it is used with real example	View Answer
	DataStage from Staging to MDW is only running at 1 row per second! What do we do to remedy?	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