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
Why fact table is in normal form?
Explain ibm infosphere information server and highlight its main features?
What are the types of jobs we have in datastage?
How do you reject records in a transformer?
What are orabulk and bcp stages?
Where do you see different stages in the designer?
What steps should be taken to improve Datastage jobs?
Differentiate between validated and Compiled in the Datastage?
What are data elements?
Where do the datastage jobs get stored?
Explain entity, attribute and relationship in datastage?
Describe the architecture of datastage?
what is repositery?
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
How to find value from a column in a dataset?