GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 85 of 126    Print  
what is the exact difference b/w LOOKUP stage , JOIN stage and MERGE stage?

  
Total Answers and Comments: 2 Last Update: November 13, 2007     Asked by: vijay 
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
November 05, 2007 04:21:57   #1  
LakshmiKrishna        
RE: what is the exact difference b/w LOOKUP stage , J...
Hi There is no major difference between three stages in terms of Functionality. They

mainly in the memory they use, the treatment of

rows with unmatched keys, and their requirements for data being input. Look Up, Join stages have only one Reject link, but Merge state can have two or more reject links for each reference link.

Thanks
LakshmiKrishna


 
Is this answer useful? Yes | No
November 12, 2007 17:56:01   #2  
Pavan Batchu        
RE: what is the exact difference b/w LOOKUP stage , J...
Lookup stage:
1.Can only return multiple matching rows from one reference.
2. Can reject rows based on constraint.
3. Can set failure.
4. Does not need partitioned and sorted input.


Merge stage:
1. Can reject rows if fail to find match.
2. Does need partitioned and sorted input.


Join stage.
1. No reject.
2. Does need partitioned and sorted input.
 
Is this answer useful? Yes | No

 Related Questions

Can a sequential file stage can read the path from other sequential file. in which the data is stored
I am trying to execute batch file which has dsjob command to run data stage job from CLI.I am getting error code = 81011 (project not found but project is there)But I can run other jobs. I am getting into problem for one particular batch.any help
View Question | Asked by : Dilip
While using oracle database as target or Source why we will use OCI stage why don't we use ODBC stage?
Read Answers (4) | Asked by : jaggu
Latest Answer : Routine : Routine is like procedure which is called to process certain operation.GoSub ADD(A,B)ADD(A,B):C=A+Breturn C ...
Read Answers (2) | Asked by : lohith
Latest Answer : main difference is routines are return the value , transform are cannot return the value.. ...
Read Answers (2) | Asked by : mallikharjuna reddy
Latest Answer : In the Filter option,u can use the UNIX command like this to filter the input records..head -3 input_file.dat ...
Read Answers (4) | Asked by : madycool
What is the difference between importing table definitions by Orchestrate Schema Definition or Plug-in Meta Data Definitions?
1.What is the use of parameters in datastage job?2.What is the difference between datastage 6 and datasttage 7.0?3.Whta is unit testing, system testing and integration testing?4.seheduling the jobs in Datastage?5.What is the difference between datastage 7.1 and datasttage 7.5?6.How to do error handling in datastage?7.how do you remove duplicates in a flatfile?
Read Answers (4) | Asked by : srinivas
Main difference between Datastage7.5 and 7.5.1a. how to upgrade the job written in 7.5 to run on 7.5.1a
View Question | Asked by : dilip kumar B
Latest Answer : In Transformer Stage click on properities tab in tool bar(Left corner tab). It displays stage properities page like all the other job properities page. There you can specify your before after stage subroutins. ...
Read Answers (1) | Asked by : suganya

 Sponsored Links

 
Related Articles

What is difference between call by value and call by reference in function?

The arguments passed to function can be of two types 1. Values passed 2. Address passed The first type refers to call by value and the second type refers to call by reference. For instance consider program1 main() { int x=50, y=70; interchange(x,y); printf(“x=%d y=%d”,x,
 

Difference between Scholarship and Grant

Difference between Scholarship and Grant While both scholarships and grants allow students to pay for their tuition without having to pay the money back there are a number of key differences between the two Knowing the difference between grants and scholarship will make it much easier for students t
 

The Difference Between Data Mart and Data Warehouse

The Difference Between Data Mart and Data Warehouse The biggest decision facing most IT managers today is whether or not they should construct the data mart before the data warehouse Many vendors will tell you that data warehouses are hard to build as well as expensive mosgoogle If you listen to som
 

Live DataStage Interview Questions

Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated questions here Live DataStage Interview Questions Published by Manoj G on 05 24 2005 Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated que
 

Sponsored Links

 



About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape