Interested to Buy Any Domain ? << Click Here >> for more details...
wat transf shud i use to achieve this
id sal id sal sum
src-1 20 tgt 1 20 40
1 20 1 20 40
2 15 2 15 35
2 20 2 20 35
- 2 Answers
- 5496 Views
- I also Faced
- E-Mail Answers
Answer Posted / rk
Use analytical function if source is database..
SELECT ID, SAL, SUM(SAL) OVER (PARTITION BY ID) AS SUM from table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the data movement modes in informatica?
During the running session, output files are created by informatica server. Enlist few of them.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
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
can you please explain me pre session and post session options?
Explain the pipeline partition with real time example?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is intricate mapping?
What are multi-group transformations?
How can we use mapping variables in informatica?
What is the way to execute pl/sql script using informatica mapping?
How to join three sources using joiner? Explain though mapping flow.
What is the function of aggregator transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Please let me know how to make encryption and decryption with example?
