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 / ds

In Stage variable:

stage_variable3 <map> stage_variable1
if column=stage_variable1 than 0 else 1 <map>
stage_variable2
column <map> stage_variable3

Put stage_variable2 as constrain to target stage.

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2247


What are the different layers in the information server architecture?

1122


Differentiate between data file and descriptor file?

1049


What is the use of datastage designer?

1149


Terminate Activity

1271


Name the different sorting methods in datastage.

1044


If you want to use a same piece of code in different jobs, how will you achieve this?

1274


What is the difference between account and directory options ?

1176


Why do you need stage variables?

1180


How you can fix the truncated data error in datastage?

1780


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1207


What are iconv and oconv?

1237


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2855


project Steps,hits, Project level HArd things,Solved methods?

2123


root tree will find which is server job and which is parallel job?

1963