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
- 7097 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
What is rank transformation in informatica
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Differentiate between a database and data warehouse?
where to store informatica rejected data? How to extract the informatica rejected data?
Could you explain what is enterprise data warehouse?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain dynamic target flat file name generation in informatica
How to Create a folder using pmrep command?
Quickly characterize reusable change?
What is the use of an aggregator cache file?
How to partition the Session?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is a filter transformation and why it is an active one?
