Hi This is Vijay,
How can your remove the duplicates in sequential File?
- 15 Answers
- 27792 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 precedence of stage variables,derivations, and constraints?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
Why do we use exception activity in Datastage?
What are the environmental settings for data stage,while working on parellel jobs?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
how to get the unique records on multiple columns by using sequential file stage only
What is process model?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How to reverse the string using SQL?
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
Demonstrate experience in maintaining quality process standards?
Teradata 
