how to sort two columns in single job in datastage.



how to sort two columns in single job in datastage...

Answer / chinna kannapuram

Just select those two fields as key fields in Sort stage or
in any other stage like Transformer stage. it will work.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Data Stage Interview Questions

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

0 Answers  


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  


What is "fatal error/rdbms code 3996" error?

0 Answers  


how can u handle null values in transformer stage.

7 Answers  


What is orabulk stage?

0 Answers  


What are some prerequisites for datastage?

0 Answers  


explain unit testing,systemtesting,integrated testing

1 Answers   CSC,


What is the difference between datastage and informatica?

0 Answers  


what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,


if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 Answers  


i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,


Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,


Categories