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
- 11863 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 are the limitations of joiner transformation?
What is a code page?
What is dimensional table?
What is mapping debugger?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How can we create index after completion of load process?
What is Data Caches size?
What is the reusable transformation?
How to extract sap data using informatica? What is abap? What are idocs?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Is it possible to create multiple domains on a single Informatica server?
What is the difference between router and filter?
Which version configuration tool used in ur project?
What is the surrogate key?
