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
- 10448 Views
- I also Faced
- E-Mail Answers
Answer Posted / nirosha g
Use an Expression Transformation connected to Source Qualifier
taking all the columns from source
In expression Transformation create two variable ports and one
output port after Input ports in same order
v_prev_sal = iif(id=1,NULL,prev_sal);
prev_sal = sal;
o_prev_sal = v_prev_sal;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain in detail about scd type 1 through mapping.
What does role playing dimension mean?
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the different ways to implement parallel processing in informatica?
Mention few power centre client applications with their basic purpose?
Write the prerequisite tasks to achieve the session partition?
Which transformation is needed while using the Cobol sources as source definitions?
What is rank transformation in informatica
What is data movement mode in Informatica and difference between them?
Could you explain what is enterprise data warehouse?
How is union transformation utilized?
Which version configuration tool used in ur project?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the difference between stop and abort in informatica
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 ?
