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
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 function of look up transformation?
What are ETL Tools?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain about cumulative Sum or moving sum?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the cumulative sum and moving sum?
What is a rank transform?
What is repository manager?
Difference between Data and Index Caches?
How do you set a varible in incremental aggregation
Performance tuning( what you did in performance tuning)
How can we store previous session logs?
What is the function of aggregator transformation?