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


i have a scenario in which i/p columns areID,salary with
1,1000 2,2000 and 3,3000 i need an extra column in the o/p
named avg(salary)how can i get it?

Answers were Sorted based on User's Feedback



i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra ..

Answer / sid

source->aggregate(with group key-ID,Avg(salary))-->Target

Is This Answer Correct ?    5 Yes 1 No

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra ..

Answer / subhash

source -> Transforemer(add column DUMMY and give value 1)
==> 2links,
1st link(with 1 hard coded value) to Copy,
1,1000,1
2,2000,1
3,3000,1
2nd Link to Join,
1,1000
2,2000
3,3000

1st linkcopy -> aggregate (Group Key-->DUMMY, take avg)--
>Join
1,2000(AVG salary)
->Join --> target
1,1000,2000
2,2000,2000
3,3000,2000

Is This Answer Correct ?    2 Yes 1 No

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra ..

Answer / ramakrishna

SRC-aggregator-tgt

In the aggregator take the avg

Is This Answer Correct ?    0 Yes 0 No

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra ..

Answer / sai

source -> Transforemer(add column and give value 1) ->
copy -> aggregate (take sum)
->Join -> tx -> target

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Data Stage Interview Questions

AGGREGATOR default datatype

0 Answers   CTS,


Define ds designer?

0 Answers  


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,


Define meta stage?

0 Answers  


hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,


explain unit testing,systemtesting,integrated testing

1 Answers   CSC,


Where do you see different stages in the designer?

0 Answers  


guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

2 Answers   TCS,


How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,


i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,


What is the roundrobin collector?

0 Answers  


How many input links can you give to a Transformer stage?

6 Answers  


Categories