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

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

3081


Can you explain kafka connector?

1250


What is the difference between datastage and datastage tx?

1014


What are the types of views in datastage director?

1724


why do u need the IOS upgradation in a FC switch

2233


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

1232


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1307


Difference between sequential file and data set?

1145


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

2114


Explain datastage architecture?

1342


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1373


What is the difference between datastage and informatica?

1064


EXPLAIN SCD

1345


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4147


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

982