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 Quality stage?
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
how can we create tables in datastage?
What is meta stage?
How can we achive parallelism
how to add a new records into source?
how to sort two columns in single job in datastage.
What is the difference between operational data stage (ods) and data warehouse?
what is the function in Transformer stage can act as Rank function in Oracle
what is the best stage in datastage parller jobs to use full out join and why
how to define satge variables in transformer stage
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4