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 / 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
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What does cheating measurement mean?
Define the various join types of joiner transformation?
What is meant by target load plan?
How to load the data from a flat file into the target where the source flat file name changes daily?
Enlist the various types of transformations.
What is the surrogate key?
What are the reusable transformations?
What is joiner transformation in informatica?
explain abt ur project architecture?
What is substr in informatica?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is Cognos script editor?
Explain sessions. Explain how batches are used to combine executions?
What is the use of source qualifier?