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

1.how to generate even numbers in surrogate or tranformar
stage ?

2. how many ways to remove duplicate values?

Answer Posted / pavan

To generate even numbers using transformer, we can make use
of stage variables. declare a stage variable say SV1 and
initialise it to 0. In the derivation of that stage
variable increment it by 2 which looks like SV1+2. By doing
this we can generate even numbers.

mail me @ akellapavankumar@gmail.com for more info.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What all the types of jobs you developed?

1179


What could be a data source system?

1008


What is the difference between datastage and datastage tx?

1064


What is merge stage?

1308


What are system variables and sequencers in datastage

1115


What is a ds designer?

1069


Highlight the main features of datastage?

1160


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

1101


Define Job control?

1143


Difference between ‘validated ok’ and ‘compiled’ in data stage?

1276


Define data aggregation?

1093


What is the sortmerge collector?

1130


Can we use target hash file as a lookup ?

3325


What is difference between symmetric multiprocessing and massive parallel processing?

1139


Explain the importance of surrogate key in data warehousing?

1187