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
What is the Rank index port in Rank transformation?
Quickly characterize reusable change?
What are active and passive transformations?
What do you mean by worklet?
list out all the transformations which use cache?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How to do the error handling of if ur source is flatfiles?
Explain lookup transformation in informatica
What is the advantage of informatica?
Mention few advantages of router transformation over filter transformation.
How to do unit testing in informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
difference between repository database and repository service?
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
What is xml source qualifier transformation in informatica?