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

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  


Define Data Stage?

0 Answers  


What are the functionalities of link partitioner?

0 Answers  


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,


What is the process of killing a job in datastage?

0 Answers  






If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,


How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,


What are the different options associated with dsjob command?

0 Answers  


DataStage Scenario based Interview Questions

1 Answers  


How can we do null handling in sequential files

3 Answers   Reliance,


job locking methods? How can we unlock the job?

3 Answers   IBM,


I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 Answers  


Categories