If we take 2 tables(like emp and dept),we use join stage
and how to improve the performance?


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

Post New Answer

More Data Stage Interview Questions

Differentiate between hash file and sequential file?

0 Answers  


What is the purpose of pivot stage and types of containers in datastage

0 Answers  


Which algorithm you used for your hashfile?

0 Answers  


Differentiate between Join, Merge and Lookup stage?

0 Answers  


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,


what is executable in DataStage?

2 Answers  


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,


What a datastage macro?

0 Answers  


Unix command to view the data in a dataset

2 Answers   IBM,


What is a quality stage?

1 Answers  


What is the use of datastage designer?

0 Answers  


Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 Answers   TCS,


Categories