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

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

1401


how to export or import the jobs in .ISX file

1176


How many types of hash files are there?

1159


what is ds administrator used for?

1149


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2192


Explain entity, attribute and relationship in datastage?

1081


in oracle target stage when we use load option and when we use upsert option?

2255


What are the types of hashed files in data stage

1095


What are constraints and derivations?

1145


How a source file is populated?

1046


What is process model?

1953


What is the different type of jobs in datastage?

950


What is datastage?

1067


Different ways a project can be moved to production ?...example ….export-import and Version control.

2427


On which interface you will be working as a developer?

1027