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?
- 4 Answers
- 7238 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasad
by using sort stage also, goto properties tab select alllow
duplicates=false.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / venu
You can use Remove Duplicate Stage and select key
as 'eno'... now the out will be without duplicates...
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / narayana reddy
we can remove the duplicate record i.e. 1001 by
1)using remove duplicate stage by giving as key = eno
2) using sort stage enter key column=eno allow duplicates
=false.
3) by giving partition alogarithms = hash
pariion key =eno that shoud dfine in properties tab.
Regards
Narayana
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / bharathram1234
we can use either rm_duplcte or srt stage..
but if You need any of duplicate record among all other then
u go 4 sort
and if u need last record or first record among all we go 4
rm_duplcte stage.
| Is This Answer Correct ? | 0 Yes | 0 No |
eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000
which dim, fact tables used in bank domain
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
What is APT_DUMP_SCORE?
Why do we use exception activity in Datastage?
what is use of SDR function?
options available in sequence job to run,validate?
What is difference between join, merge and lookup stage?
What is the use of Row generator stage?
In which situations we can use normal and sparse lookup stages
difference between function and procedure...
how CAN we remove duplicates in dataset?
Teradata 
