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?
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 |
how do u capture duplicates through sort & transformer
What is diff between Junk dimensions and conform dimension?
what is the exact difference between dataset and fileset in datastage?
What is mapping?
how to find diff between 2 dates without using Icon... funtions?
Which algorithm you used for your hashfile?
how to define satge variables in transformer stage
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
Define orabulk and bcp stages?
What is datastage?
If the job aborted in a sequencer, how can we start that from the previews successful job.
i want job aborted after some records are loaded into output by using only sequential stage and dataset