Interested to Buy Any Domain ? << Click Here >> for more details...
Can aggregator and transformer stages use to sort the data?
How ?
- 2 Answers
- 12588 Views
- I also Faced
- E-Mail Answers
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 |
I have a few records all are same structures data, I want to store data in multiple targets how?
How can we do null handling in sequential files?
How can one find bugs in job sequence?
What is a merge in datastage?
How To find the location of APT_confid file
Differentiate between operational datastage (ods) and data warehouse?
What is RCP
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
how to sort two columns in single job in datastage.
Define repository tables in datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
Teradata 
