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...

one file contains
col1
100
200
300
400
500
100
300
600
300
from this i want to retrive the only duplicate like this
tr1
100
100
300
300
300 how it's possible in datastage?can any one plz explain
clearley..........?

Answer Posted / sudheer

- aggregator -
seq. file - copy join - filter - seq.op


in arrg - cnt rows
in join - left outer join - left as seq.file data
in filter - where cond. - cnt>1

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Terminate Activity

1278


Explain connectivity between datastage with datasources?

976


What are the different type of jobs in datastage?

1043


How complex jobs are implemented in datstage to improve performance?

1041


What are the functionalities of link collector?

1085


What is job control?

1111


What is the difference between passive stage and active stage?

1538


what are the devoleper roles in real time? plz tell i am new to datastage....

2162


How many types of views are there in a datastage director?

1282


What are routines in datastage? Enlist various types of routines.

1101


Define meta stage?

1200


What are the various kinds of containers available in datastage?

1048


How a server job can be converted to a parallel job?

1094


How do you start developing a datastage project?

1103


What all are the different way to run a job?

1092