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
- 8248 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 is target designer and target load order?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Which is the t/r that builts only single cache memory?
What are the differences between oltp and olap?
What do you mean by blocking transformation?
What is fact table? Explain the different kinds of facts.
How big was your fact table
Informatica Checkpoints
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How to extract the informatica rejected data?
What is workflow monitor?
What is transformation?
What is informatica? Why do we need it?
How do you migrate data from one environment to another?
what is $$$$?
