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 / 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 prerequisite tasks to achieve the session partition?
What is informatica metadata and where is it stored?
What are the tuning techniques you applied during your last project
Describe data concatenation?
can anyone explain me about retail domain project in informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Name the different lookup cache(s)?
How we can create indexes after completing the loan process?
Explain the difference between a data warehouse and a data mart?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is target designer and target load order?
What you know about transaction control transformation?
Explain the informatica workflow?
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?
What are the types of caches in lookup? Explain them.