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

take two stage variables

sV1: Input_column

sV2: if Input_column = sV1 then 0 else 1

and put 'sV1=1' as constraint

Plz correct me, If am wrong.....

Is This Answer Correct ?    4 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2418


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3280


Explain the datastage parallel extender (px) or enterprise edition (ee)?

1188


What are the different types of lookups in datastage?

1019


What is usage analysis in datastage?

1274


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

2118


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2055


How to read the length of word in unix?

1321


What are the various kinds of containers available in datastage?

987


What is a datastage job?

973


What is aggtorec restructure operator?

1366


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2669


Highlight the main features of datastage?

1106


Can you implement SCD2 using join, transformer and funnel stage?

1514


how can we create rank using datastage?what is the meaning of rank?

8719