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 / 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 |
Post New Answer View All Answers
What is the use of datastage director?
I have a few records just I want to store data in to targets cycling way how?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is merge stage?
Have you have ever worked in unix environment and why it is useful in datastage?
Difference between data warehousing and olap?
How will you move hashed file from one location to another location?
Which commands are used to import and export the datastage jobs?
What is a merge?
What are the various kinds of containers available in datastage?
What are data elements?
Describe routines in datastage? Enlist various types of routines.
Differentiate between hash file and sequential file?
What is staging variable?
What is the difference between an operational datastage and a data warehouse?