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
- 11553 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
How can we create index after completion of load process?
Tell me about MD5 functions in informatica
Explain the mapping variable usage example in informatica
where to store informatica rejected data? How to extract the informatica rejected data?
EXL informatica Questions
What will be the approach?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the different types of transformation available in informatica.
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
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 are the types of data warehouses?
What does cheating measurement mean?
How to open an older version of an object in the workspace?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
how we can load rejected record's at run time?(not through bad files)
