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
Whats the difference between informatica powercenter server, repositoryserver and repository?
How do you use reject loader.
What is fact table? Explain the different kinds of facts.
if we have a delimiters at unwanted places in a flat file how can we over come those.
Which files are created during the session rums by informatics server?
difference between informatica 8.1.1 and 8.6
How to implement security measures using repository manager?
scenario where i can use only concurrent execution of workflow.
Under which circumstances, informatica server creates reject files?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How to do the error handling of if ur source is flatfiles?
Explain lookup transformation in informatica
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is dimensional table? Explain the different dimensions.
How can we use mapping variables in informatica? Where do we use them?