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

What are the functionalities of link collector?

1133


What is the difference between the local container and shared container?

1141


What are the types of jobs we have in datastage?

1116


how to sort two columns in single job in datastage.

2952


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3397


How you Implemented SCD Type 1 & Type 2 in your project?

4174


What is job control?

1191


Demonstrate experience in maintaining quality process standards?

2629


What are iconv and oconv?

1291


What are the steps required to kill the job in Datastage?

1262


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

2213


What is size of a transaction and an array means in a datastage?

1364


What are the various kinds of containers available in datastage?

1100


What is the importance of the exception activity in datastage?

1109


How complex jobs are implemented in datstage to improve performance?

1091