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 / 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
Explain the different dimensions.
Enlist the differences between database and data warehouse.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the data movement modes in informatica?
How can we improve session performance in aggregator transformation?
How to Create a folder using pmrep command?
What is meant by pre and post session shell command?
can u any challenge your project?
What is powercenter on grid?
Explain why we use partitioning the session in informatica?
What is informatica? Why do we need it?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is mapplet in informatica?
have u done any performance tuning? how u ll do?