Can aggregator and transformer stages use to sort the data?
How ?

Answers were Sorted based on User's Feedback



Can aggregator and transformer stages use to sort the data? How ?..

Answer / kumar

go to partition--->select the partiton name other than auto-
-->check perform sort.

Is This Answer Correct ?    1 Yes 0 No

Can aggregator and transformer stages use to sort the data? How ?..

Answer / srinivas

We can sort the data by using Aggregator and Transformer

If we use the Aggregator will get only specified coulmns will not get all source columns.

If we use the transformer will get all columns with sorted output.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

0 Answers  


How can we do null handling in sequential files?

3 Answers   Reliance,


i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,


What are stage variables and constants?

0 Answers  


Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,


What are the third party tools you used in your project?

1 Answers   IBM,


What is a merge?

0 Answers  


explain about citrix scheduling tool in datastage

0 Answers   HSBC,


how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,


is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,


how to cleansing data

6 Answers   Cap Gemini,


plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,


Categories