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

source
name sal
aaaa 2000
bbbb 3000
abcd 5000


Target
name sal
aaaa 2000
bbbb 3000
abcd 5000
total 10000


how to get total as new row and sum as 10000

thanks

Answer Posted / babu

Hi,
Mapping:

SRC==>EXP==>AGGR==>UNION
|==>TRG
SRC==>

EXP:In first DFD we have EXPR and AGGr,in EXPR we have to
take one output port with a constant value by using that
output port calculate the sum sal in AGGR.In AGGR take one
output port that as name field with constant value(total)
and the sum sal field as sal after that UNION trns is there
union the two DFD's,finally we get the what we expect.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the Rank index port in Rank transformation?

1062


Quickly characterize reusable change?

1123


What are active and passive transformations?

1089


What do you mean by worklet?

1071


list out all the transformations which use cache?

1187


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2068


How to do the error handling of if ur source is flatfiles?

1968


Explain lookup transformation in informatica

1079


What is the advantage of informatica?

1069


Mention few advantages of router transformation over filter transformation.

1023


How to do unit testing in informatica?

1176


Different qualification between a related rotate toward the sky and isolates look upward?

990


difference between repository database and repository service?

1155


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2038


What is xml source qualifier transformation in informatica?

1218