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
Where the datastage stored his repository?
What are the main features of datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the different plug-ins stages used in your projects?
What are some different alternative commands associated with "dsjob"?
How to perform incremental load in datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Distinguish between informatica & datastage. Which one would you choose and why?
How many types of hash files are there?
What is the differentiate between data file and descriptor file?
How to manage date conversion in Datastage?
What is the difference between odbc and drs stage?
What are the features of datastage flow designer?
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 to implement scd2 in datastage 7.5 with lookup stage