how to get the unique records on multiple columns by using
sequential file stage only
- 3 Answers
- 9346 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chandu
in sequential file there is one option is there i.e
filter.in this filter we use unix commands like what ever we
want.in this question we use uniq command in filter.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / todearhari
Just a small correction to Above Answer ,First we need to sort the Data then use the Uniq then only you will get Complete uniq records as uniq compares line by line.
Command:
Sort |Uniq
| Is This Answer Correct ? | 2 Yes | 0 No |
how many write modes are there in ds
what are the errors,warnings in datastage
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
how to call sequential generator in datastage?
Explain usage analysis in datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
what is the use of surogate key in datastage
What is quality stage?
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?
Teradata 
