Can aggregator and transformer stages use to sort the data?
How ?
Answer Posted / 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 View All Answers
Have you used Unstructured data?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
how many rows sorted in sort stage by default in server jobs
Name the third party tools that can be used in datastage?
Can you highlight the main features of ibm infosphere information server?
What is data partitioning?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What all are the different way to run a job?
Name the different sorting methods in datastage.
What are the difference types of stages?
How do you reject records in a transformer?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Difference between data warehousing and olap?
How do y read Sequential file from job control?
Demonstrate experience in maintaining quality process standards?