how to get the unique records on multiple columns by using
sequential file stage only
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
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the differences between datastage and informatica?
How do you start developing a datastage project?
What is the difference between datastage and datastage tx?
What are the repository tables in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the steps needed to create a simple basic datastage job?
What is meta stage?
What is difference between symmetric multiprocessing and massive parallel processing?
which r the connectors used in san?
How will you move hashed file from one location to another location?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Is it possible to query a hash file?
What is a folder? Difference types of stages?
Can you implement SCD2 using join, transformer and funnel stage?