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


Please Help Members By Posting Answers For Below Questions

What is the use of datastage director?

597


I have a few records just I want to store data in to targets cycling way how?

1909


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

968


What is merge stage?

777


Have you have ever worked in unix environment and why it is useful in datastage?

661






Difference between data warehousing and olap?

661


How will you move hashed file from one location to another location?

1671


Which commands are used to import and export the datastage jobs?

992


What is a merge?

684


What are the various kinds of containers available in datastage?

581


What are data elements?

671


Describe routines in datastage? Enlist various types of routines.

595


Differentiate between hash file and sequential file?

597


What is staging variable?

638


What is the difference between an operational datastage and a data warehouse?

647