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 to initialize environment variables?
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
What are routines in datastage?
WHAT IS FORCE COMPILE?
types of errors in datastage?
Highlight the main features of datastage?
What are the functionalities of link collector?
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
How do you schedule or monitoring the job?
Nls stands for what in datastage?