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
- 11862 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
Separate from an archive server and a powerhouse?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is depict expression change?
Explain the difference between mapping parameter and mapping variable?
Scheduling properties,whats the default (sequential)
Is there any way to read the ms excel datas directly into informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Which transformation is needed while using the Cobol sources as source definitions?
Design time, run time. If you don't create parameter what will happen
What are different types of transformations available in informatica?
Why union transformation is an active transformation?
What are batches?
What is rank transformation?
What is sequence generator transformation in informatica?
Different circumstance which drives informatica server to expel records?
