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

Can you explain how could anyone drop the index before loading the data in target in datastage?

1492


Differentiate between datastage and datastage tx?

1041


What are the types of containers in datastage?

1181


How many Key we can define in remove duplicate stage?

1360


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2160


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5106


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3106


What is the sortmerge collector?

1121


Name the third party tools that can be used in datastage?

1068


what is 'reconsideration error' and how can i respond to this error and how to debug this

2609


Define Merge?

1298


Can you explain players in datastage?

1179


What is ibm datastage flow designer?

1131


how to abort the job its matain duplicates?

2570


how can we create rank using datastage?what is the meaning of rank?

8769