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
11545 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

Explain joiner transformation in informatica

1105

Explain the mapping variable usage example in informatica

1132

What is the different lookup cache(s)?

1072

How to load the data from a flat file into the target where the source flat file name changes daily?

1037

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1965

How to load last n records of file into target table - informatica

1050

have u done any performance tuning? how u ll do?

2276

How to extract the informatica rejected data?

1197

What is informatica powercenter repository?

1170

can we override a native sql query within informatica? Where do we do it?

1096

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7163

What are session parameters ? How do you set them?

1821

What all join we can perform in LOOKUP transformation?

953

can anyone explain me about retail domain project in informatica?

7925

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1067