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

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,


How do u call shellscript/Batch file from DS?

4 Answers   HP,


how to run jon in unix back round process what is command use in runing a job?

2 Answers   HSBC,


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

5 Answers   IBM,


my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,


pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers  


How to convert RGB Value to Hexadecimal values in datastage?

0 Answers  


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

0 Answers  


when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,


Could anyone give brief explanation bout datastage admin

0 Answers  


How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,


Define Merge?

0 Answers  


Categories