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
- 8099 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / babu
Hi Chinthi
You will do the above mapping,definely you can get
whatever you want.
Please check and intimate in case of any issues.
dwarak.vbr@gmail.com
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the use of target designer?
What is meant by target load plan?
what is diff b/t sorter t/r and agg have the option sorter property...
Define joiner transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Which is the t/r that builts only single cache memory?
generate date / time dimension in informatica
How to delete duplicate row using informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explian the Process of deployment groups in informatica
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Define Pmrep command?
How big was your fact table
Can informatica load heterogeneous targets from heterogeneous sources?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
