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

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


Please Help Members By Posting Answers For Below Questions

How to generate sequence numbers?

710


How to handle decimal places while importing a flatfile into informatica?

810


whats the logic to load the lower level of granularity of data to fact table.

1911


Different sorts of metadata that stores in the storage facility?

667


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

751






without table how to come first record only in oracle?

1940


What are mapplets? How is it different from a Reusable Transformation?

728


Why sorter is an active transformation?

840


What is the scenario which compels informatica server to reject files?

710


Explain the difference between a data warehouse and a data mart?

678


Differences between version 7.x and 8.x.

1522


What is workflow monitor?

695


What do you mean incremental aggregation?

716


tell me about your project functionality

1970


Which means the first record should come as last record and last record should come as first record and load into the target file?

696