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
- 4 Answers
- 7098 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by filter transformation?
How can we use batches?
can u any challenge your project?
What happens when a session fails and you click on recover?
What are the various types of transformation?
What is the different lookup cache(s)?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Tell me about Propagate functions in informatica
can we override a native sql query within informatica? How do we do it?
Why do we need informatica?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
How we can create indexes after completing the load process?
What is exclusive and normal mode for repository services?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain pmcmd command usage in informatica
