Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the unique records on multiple columns by using
sequential file stage only
- 3 Answers
- 9932 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Describe the main features of datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What is the project in datastage?
Differentiate between datastage and informatica?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Define project in datastage?
root tree will find which is server job and which is parallel job?
Differentiate between odbc and drs stage?
Whats difference betweeen operational data stage (ods) and data warehouse?
Notification Activity
What are data elements?
how to sort two columns in single job in datastage.
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How we can covert server job to a parallel job?
What is use Array size in datastage
