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
- 5604 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
How to load a Dimension ? and how to load a fact table?
How do you handle two sessions in Informatica
What is the Rank index port in Rank transformation?
How can you generate reports in informatica?
What is the difference between a connected look up and unconnected lookup?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is Session and Batches?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Is there any target staging area in informatica not staging area
Explain your project of banking domian.
What does cheating measurement mean?
What is the reusable transformation?
tell me the rules and responsblites in our project(my project is development)
What is union transformation?
What is Index Caches size?
