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
- 5470 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 happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Can you use flat files in Mapplets.
Why do you use Mapping Parameter and mapping variable?
can you please explain me pre session and post session options?
In which transformation you cannot drag ports into it?
update strategy transformation in informatica
What is workflow manager?
difference between informatica 8.1.1 and 8.6
What is domain and gateway node?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
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?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
what is the difference between informatica6.1 and infomatica7.1
Enlist the advantages of informatica.
