actually i need total as new record value as 10000

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 / chinthi

4 Answers
8242 Views
Polaris, I also Faced
E-Mail Answers

Answer Posted / chinthi

actually i need total as new record value as 10000

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what transformation and how many are there in informatica?

1021

How do you handle two sessions in Informatica

1217

What is the Rank index port in Rank transformation?

1102

What's the layout of parameter file (what does a parameter file contain?)?

2434

Explain the pipeline partition with real time example?

1200

Write the different tools in the workflow manager?

1113

Explain incremental aggregation in informatica

1183

Differences between connected and unconnected lookup?

1269

What are Dimensional table?

1120

Explain the informatica workflow?

1125

Explain scd type 3 through mapping.

1051

What are the differences between source qualifier and joiner transformation?

1135

How big was your fact table

1859

What is a node in Informatica?

1085

What do you understand by SOA of Informatica?

1041