Differentiate between Join, Merge and Lookup stage?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

How to create user defined environment varibale(parameter)?

1 Answers   TCS,


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

0 Answers   IBM,


how many stages are there in Datastage... Please clarify mee??

3 Answers  


Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,


3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  






Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,


How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers  


What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  


How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,


options available in sequence job to run,validate?

0 Answers   CTS,


how to delete one row in target dataset

0 Answers   Satyam,


i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,


Categories