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
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 |
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
How can you display only hidden files in UNIX
how to declare array in plsql?
Clarify the utilization of aggregator cache record?
What are the out put files that the informatica server creates during the session running?
can we see default group,when we use router?if yes how?
What is primary and backup node?
Is it possible to update the target table with PK?
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
What is Code Page Compatibility?
What is active and passive transformation?
how to move the mappings from your local machine to claint place?