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
- 5504 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / uma
Source -> SQ -> Agg T/F to get sum (group by id) -> Joiner (to join SQ and output of aggr transformation) -> Target
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
How to do unit testing in informatica?
What is a filter transformation and why it is an active one?
Whatis the difference between View and Materialized View ?
what are the row and column separations in Flat Files
What are the tasks that can be performed using sq?
what is the gap analysis?
What is the benefit of session partitioning?
How to join three sources using joiner?
What is a candidate key?
What are the guidelines to be followed while using union transformation?
What are the scheduling options to run a sesion?
What are Dimensional table?
Teradata 
