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 |
Demonstrate experience in maintaining quality process standards?
Define repository tables in datastage?
1.what is materialized data? 2.how to view the materialized data?
describe the Steps to confiure a Qlogic switch
Lookup constraints
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
If you want to use a same piece of code in different jobs, how will you achieve this?
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
How rejected rows are managed in datastage?
What are stage variables, derivations and constants?
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks