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
- 30829 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 |
wt is the diff b/w odbc and oracle stage
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
What is process model?
Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .
Can you implement SCD2 using join, transformer and funnel stage?
What are the benefits of datastage?
What steps should be taken to improve Datastage jobs?
How do you load 10 different sources with 10 different layouts to 10 different tables?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
How many nodes supported by a one cpu in parallel jobs?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
Teradata 
