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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kulasekhar reddy tholeti
Try it 100% you will get answer.
Select name,no from source
union
select "total",sum(sal) from source;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / babu
Hi Chinthi
You will do the above mapping,definely you can get
whatever you want.
Please check and intimate in case of any issues.
dwarak.vbr@gmail.com
Is This Answer Correct ? | 0 Yes | 1 No |
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Do you have to change the reject file b4 using reject loader utility.
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
What is a repository manager?
How do you use reject loader.
what is hash table in informatica?
What is flashback table ? Advance thanks
what is the difference between repository & Intergration service
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?