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
- 4 Answers
- 7893 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 are the data movement modes in informatica?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Explain the types of lookup transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to partition the Session?
Explain pushdown optimization and types in informatica
What is Index Caches size?
Explain the informatica workflow?
Can you generate sequence numbers without using the sequence generator transformation?
What is event and what are the tasks related to it?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is source qualifier transformation in informatica?
Explain Dataware house architecture .how data flow from intial to end?
While migrating the data from one environment to another environment how would you manage the connections?
What is the format of informatica objects in a repository?
