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?
Answer Posted / 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 |
Post New Answer View All Answers
What are the different layers in the information server architecture?
How to reverse the string using SQL?
What are the some differences between 7.x and 8.x version of datastage?
What is the process of killing a job in datastage?
Why do you need stage variables?
How to read multiple files using a single datastage job if files have the same metadata?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What steps should be taken to improve Datastage jobs?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Explain ibm infosphere information server and highlight its main features?
explain about citrix scheduling tool in datastage
Explain the datastage parallel extender (px) or enterprise edition (ee)?
what are the errors,warnings in datastage
What is the difference between datastage and informatica?
CHANGE CAPTURE