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
How to generate sequence numbers?
How to handle decimal places while importing a flatfile into informatica?
whats the logic to load the lower level of granularity of data to fact table.
Different sorts of metadata that stores in the storage facility?
Under what condition selecting sorted input in aggregator may fail the session?
without table how to come first record only in oracle?
What are mapplets? How is it different from a Reusable Transformation?
Why sorter is an active transformation?
What is the scenario which compels informatica server to reject files?
Explain the difference between a data warehouse and a data mart?
Differences between version 7.x and 8.x.
What is workflow monitor?
What do you mean incremental aggregation?
tell me about your project functionality
Which means the first record should come as last record and last record should come as first record and load into the target file?