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
client know skid info?
What is the difference between informatica and datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is ibm datastage flow designer?
Define oconv () and iconv () functions in datastage?
Differentiate between data file and descriptor file?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Enlist various types of routines in datastage.
what is the use of surogate key in datastage
If you want to use a same piece of code in different jobs, how will you achieve this?
How do you generate sequence number in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Define APT_CONFIG in Datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?