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



wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 ..

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

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 ..

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

Post New Answer

More Informatica Interview Questions

what is the size of u r source(like file or table)?

0 Answers   HP,


What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  


How can we use mapping variables in informatica? Where do we use them?

0 Answers  


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,


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?

7 Answers   IBM, TCS,






What is the Rankindex in Ranktransformation?

7 Answers  


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 ??

2 Answers  


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.

0 Answers   iGate,


Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  


explain different types of modeling.

2 Answers  


Categories