Hi In the variable port you have add pre_sal = v_SAL v

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

Question Posted / moorthy, g

9 Answers
11442 Views
I also Faced
E-Mail Answers

Answer Posted / moorthy, g

Hi
In the variable port you have add
pre_sal = v_SAL
v_sal=SAL
SAL = SAL
o_update_sal = pre_SAL

Best Regards,
Moorthy. G

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to extract sap data using informatica? What is abap? What are idocs?

1128

What is an expression transformation in informatica?

987

Explain transaction control transformation in informatica

1230

What is a standalone command task?

1165

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2025

What is the need for an etl tool?

1034

What is the format of informatica objects in a repository?

994

What is rank transform?

962

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1975

What is joiner transformation in informatica?

1011

How to partition the Session?

1068

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1154

Clarify the aggregator change?

997

As union transformation gives UNION ALL output, how you will get the UNION output?

1069

What are the types of data warehouses?

1459