Interested to Buy Any Domain ? << Click Here >> for more details...
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000
4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement
is like this id name sal up_sal,1 aa 1000 null,2 bb 2000
1000, 3 cc 3000 2000
4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on
so how can i get it plez reply for this as soon as possible
, thanks in advanced
- 9 Answers
- 11642 Views
- I also Faced
- E-Mail Answers
Answer Posted / moorthy, g
Hi
In the variable port you have add
pre_sal = v_SAL
v_sal=SAL
SAL = SAL
o_update_sal = pre_SAL
Best Regards,
Moorthy. G
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an expression transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are session parameters ? How do you set them?
How many ways are there to create ports?
How do you update the records with or without using update strategy?
What is DR strategy for Informatica project?
What does update strategy mean, and what are the different option of it?
What are ETL Tools?
What is event and what are the tasks related to it?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain transaction control transformation in informatica
What is domain and gateway node?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is lookup transformation?
