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 |
what is the size of u r source(like file or table)?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
How can we use mapping variables in informatica? Where do we use them?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
What is the Rankindex in Ranktransformation?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Under what condition selecting sorted input in aggregator may fail the session?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
explain different types of modeling.