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
- 2 Answers
- 4439 Views
- I also Faced
- E-Mail Answers
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
What is joiner transformation in informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Where are the source flat files kept before running the session?
Explain transaction control transformation in informatica
Explain sessions. Explain how batches are used to combine executions?
Explain lookup transformation in informatica
Explain the use of aggregator cache file?
Write the program through which the records can be updated?
What are the popular informatica products?
Define filter transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What do you mean by worklet?
Please let me know how to make encryption and decryption with example?
What are the transformations that are not supported in mapplet?
Explain the pipeline partition with real time example?
