Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5590 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
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How to load last n records of file into target table - informatica
what is size of u r database?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How many types of sessions are there in informatica.please explain them?
Differences between connected and unconnected lookup?
What are mapplets?
What are Dimensional table?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is a code page?
What are the different components of powercenter?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Explain the aggregator transformation?
