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 |
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
Why do you need stage variables?
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
What are system variables and sequencers in datastage
What is quality stage?
what is sparse lookup?
What is the differentiate between data file and descriptor file?
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
Demonstrate experience in maintaining quality process standards?
How can we achive parallelism