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
- 11627 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
What is the surrogate key?
What is rank transform?
Explain in detail about scd type 1 through mapping.
permutations of mapplet
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is informatica metadata and where is it stored?
tell me the rules and responsblites in our project(my project is development)
Explain the aggregator transformation?
without table how to come first record only in oracle?
How many input parameters can exist in an unconnected lookup?
How to extract sap data using informatica? What is abap? What are idocs?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is InformaticaPowerCenter?
What are different types of transformations available in informatica?
What are the popular informatica products?
