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
- 9050 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 |
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How many input links can you give to a Transformer stage?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
Which commands are used to import and export the datastage jobs?
What are the processing stages?
What is a range lookup?
what is the use of DSattchJob?DetachJob? where can we find it?
how to sort two columns in single job in datastage.
How to perform incremental load in datastage?
CHANGE CAPTURE
What are the steps needed to create a simple basic datastage job?
Teradata 
