Interested to Buy Any Domain ? << Click Here >> for more details...
Hi This is Vijay,
How can your remove the duplicates in sequential File?
- 15 Answers
- 30553 Views
- HCL, Scope International, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
Hi All,
Good Day...............!
Go to Sequential File ---> Select Filter Property ----->
Set Filetr = sort | Uniq......
Now its Working properly......
if u have any doubts pls make me a call 8055902709
| Is This Answer Correct ? | 23 Yes | 0 No |
Answer / rajesh
Go to Sequential File and then Select Filter Property
Set Filter = sort|uniq...........
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / prasu
Hi Manoj,
Where u will give the Distinct Keyword...This is not a
table ..it is file...
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sravanthi reddy
Hi this is sravanthi. if u click the options in the right
side bottom u will find filter option
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / kiran
Hai vijay.., ur query nt proper.seq is sourcd or
target.just say.i wil give proper ans
| Is This Answer Correct ? | 9 Yes | 5 No |
Answer / arun
Sort the incoming data using a sort stage & use remove
duplicates on the key columns. This will remove the
duplicates in ur source file.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / chowdary
in sequntial file options filter--> sort | uniq -d
this will give best performence to remove duplicates.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sabariesh
Hi Sravanthi, if i have any more doubts how i can i contact
you..?
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chinky
where can we select filter property in sequential file?
| Is This Answer Correct ? | 1 Yes | 1 No |
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh
what is the differeces between hash and modulus partition methods
What are the areas of application?
what is the use of surogate key in datastage
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
What is the precedence of stage variables,derivations, and constraints?
what is snow flack schema?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
Describe stream connector?
Teradata 
