Can aggregator and transformer stages use to sort the data?
How ?
Answers were Sorted based on User's Feedback
Answer / kumar
go to partition--->select the partiton name other than auto-
-->check perform sort.
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
how will u design file watch jobs?
what is usage of datastage with materialized views
Explain usage analysis in datastage?
Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?
15 Answers Scope International,
How can one find bugs in job sequence?
What is the version control how can i apply this in DataStage can any one tell me the anser
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
What are the steps needed to create a simple basic datastage job?
what is 'reconsideration error' and how can i respond to this error and how to debug this
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
What is the use of datastage designer?
how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?