how to get the unique records on multiple columns by using
sequential file stage only
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 |
What is the difference between passive stage and active stage?
How can we improve performance of data stage jobs?
When we will go for Data elements?
How can we run same job in 1 day 2 times
Can you explain how could anyone drop the index before loading the data in target in datastage?
Can you filter data in hashed file?
What are the some differences between 7.x and 8.x version of datastage?
types of errors in datastage?
How to display all the duplicate records from the oracle Table?
when will you go for dataset and fileset?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
What is the use of Row generator stage?