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


Please Help Members By Posting Answers For Below Questions

client know skid info?

1610


What is the difference between informatica and datastage?

630


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

339


What is ibm datastage flow designer?

657


Define oconv () and iconv () functions in datastage?

854






Differentiate between data file and descriptor file?

592


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

3294


Enlist various types of routines in datastage.

619


what is the use of surogate key in datastage

1784


If you want to use a same piece of code in different jobs, how will you achieve this?

763


How do you generate sequence number in datastage?

605


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1112


Define APT_CONFIG in Datastage?

646


Distinguish between informatica & datastage. Which one would you choose and why?

563


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1781