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
- 11630 Views
- I also Faced
- E-Mail Answers
Answer Posted / babu
Hi All,
Mapping:
========
Src==>SQ==>Exp(id,name,sal,up_sal,V_PreviousSal(variable
port))==>Trg
Exp Transformation is have 5 ports,
1.id port (i/o)
2.name (i/o)
3.sal (i/o)
4.up_sal is the ouput port =V_Previoussal
5.V_PreviousSal port is the output port,the value of this
port is sal
Expression of this(V_PreviousSal) port =sal
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between router and filter?
How to update or delete the rows in a target, which do not have key fields?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is informatica etl tool?
What is a standalone command task?
What are the restrictions of union transformation?
What is a predefined event?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How do you load alternate records into different tables through mapping flow?
can anyone explain me about retail domain project in informatica?
What is lookup change?
hi real timers . iam waiting for ur reply regarding ETL TESTING
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
What is a sorter transformation?
How can we store previous session logs?
