Hi This is Vijay,
How can your remove the duplicates in sequential File?
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 |
EXPLAIN SCD
explain about citrix scheduling tool in datastage
What is mapping?
when we have to go for a sequential file stage & for a dataset in datastage?
What is diff between Junk dimensions and conform dimension?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
what is the use of invokation id
Difference between in process and inter process?
How do you remove duplicate values in datastage?
How many Key we can define in remove duplicate stage?
What is the use of datastage designer?
Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.