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

how to remove duplicates in transformer stage by using
stage variables?one example?

Answer Posted / amit

using hash partition technique, we can bring duplicate data(based on key columns) in one partition. Then in stage constraints filter out data with setting @inrownum = 1.

This will remove duplicate in transformer stage.

Is This Answer Correct ?    0 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various kinds of the hash file?

1151


What is the command line function to import and export the ds jobs?

1153


What are the main differences you have observed between 7.x and 8.x version of datastage?

1089


Differentiate between data file and descriptor file?

1060


What are the different kinds of views available in a datastage director?

1030


Differentiate between datastage and datastage tx?

1051


What is the flow of loading data into fact & dimensional tables?

1063


What are routines in datastage?

1329


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?

2213


Lookup constraints

1257


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722


How to convert RGB Value to Hexadecimal values in datastage?

3998


What are the types of containers in datastage?

1191


What is the method of removing duplicates, without the remove duplicate stage?

1027


What is a merge?

1169