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 |
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?
How can we do null handling in sequential files?
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?
What are stage variables and constants?
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
What are the third party tools you used in your project?
What is a merge?
explain about citrix scheduling tool in datastage
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
is it possible to access the same job by two users at a time in DataStage?
how to cleansing data
plz tell me some dimentional and fact table names in banking project?