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

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

980


What is ibm datastage?

1023


What are the primary usages of datastage tool?

1129


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3523


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2521


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

1279


What is job control?

1198


What is the difference between orabulk and bcp stages?

1073


What is the difference between the local container and shared container?

1144


What is difference between join, merge and lookup stage?

1150


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2491


How rejected rows are managed in datastage?

1575


What is the differentiate between data file and descriptor file?

1412


What are system variables and sequencers in datastage

1182


What are the types of containers and how to create them?

1022