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
Distinguish between informatica & datastage. Which one would you choose and why?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How can we improve performance of data stage jobs?
Could anyone give brief explanation bout datastage admin
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What steps should be taken to improve Datastage jobs?
Define ds designer?
What are the different common services in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how to delete one row in target dataset
What is a merge in datastage?
What is oci?
On which Dimension Table you implemented SCD Type in your Project
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How do you import and export data into datastage?