1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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 / kkkk

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / nirosha g

Use an Expression Transformation connected to Source Qualifier
taking all the columns from source
In expression Transformation create two variable ports and one
output port after Input ports in same order
v_prev_sal = iif(id=1,NULL,prev_sal);
prev_sal = sal;
o_prev_sal = v_prev_sal;

Is This Answer Correct ?    2 Yes 0 No

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

Answer / 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

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

Answer / dev

Thanks a lot to both babu and moorthy for ur valuable time
for my doubt but i have another doubt is that as we are
assigning the port sal to prev_sal port how it holds the
previous sal as becz the currently it is holding the current
sal...... can u just explain me ...

Is This Answer Correct ?    0 Yes 0 No

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

Answer / swapnil

use CUMM(sal) function in expression like this:
id(i/o)
sal(i/o)
cum_sal(v)= cumm(sal)
up_sal= iif(sal=cumm_sal, NULL, cumm_sal)

Is This Answer Correct ?    0 Yes 0 No

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

Answer / dev

if u do not know then don't post any useless
things......plez its a request ......

Is This Answer Correct ?    0 Yes 0 No

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

Answer / ankit kansal

Hi,
If you are not sure about the id's sorting order

count = count+1
v_sal = IIF(count=1,null,v_prev_sal)
v_prev_sal = sal
out_sal = v_sal

http://deepinopensource.blogspot.com/

Is This Answer Correct ?    0 Yes 0 No

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

Answer / babu

Hi Dev,

do u know about ports execution order in informatica,
the order of the ports execution is
1.Input port
2.I/O input nad output port
3.Outputport
4.Variable port

still if u have any issues regarding this please call to me
(08861145051)

Is This Answer Correct ?    2 Yes 3 No

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

Answer / ravi

Dear Babu,
Hope the execution sequence of the ports are as:
1. Input Port
2. Variable port.
3. Output.

Will u acknowledge for the above pl..??

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

what is incremantal aggregation?

1 Answers  

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

can session assigned multiple mappings or not?

2 Answers   Zensar,

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

What are the types of schemas we have in data warehouse.

0 Answers  




In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,

what is metadata?

8 Answers   Satyam,

What is Cognos script editor?

0 Answers   Cognizant,

Which is better performance wise database or file?How?

2 Answers   TCS,

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,

For more Informatica Interview Questions Click Here
Categories