Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

Answer Posted / nish

remove duplicate-> retail last

Alternate MEthod: if there are only two occurences then sort stage-> descending-> remove duplicates

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert RGB Value to Hexadecimal values in datastage?

3923


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

1291


What is the difference between server job and parallel jobs?

1091


Define ds designer?

1212


What is apt_config in datastage?

1081


How can one find bugs in job sequence?

1314


What is the difference between datastage and informatica?

1057


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2924


What are the different types of lookups in datastage?

1006


Why do we use exception activity in Datastage?

1224


What are the types of containers and how to create them?

927


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1679


How can we improve performance of data stage jobs?

963


Differentiate between data file and descriptor file?

986


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2040