Try it 100% you will get answer. Select name,no from source

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

Question Posted / kulasekhar reddy tholeti

4 Answers
8084 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

Please Help Members By Posting Answers For Below Questions

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1082

Is there any way to read the ms excel datas directly into informatica?

1022

How to handle decimal places while importing a flatfile into informatica?

1192

What is option by which we can run all the sessions in a batch simultaneously?

1144

How can we use batches?

1025

Explain in detail scd type 2 through mapping.

1041

How can we handle two sessions in informatica?

1033

Explain your project of banking domian.

1652

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1954

What are the types of presistent cache in look up tr.

2055

What are mapplets?

1274

What is the difference between router and filter?

1270

in reporting we add some new objects,how we get the count of the newly added objects to the report

2194

What is dimensional table? Explain the different dimensions.

1172

What is status code in informatica?

1021