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

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;

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

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

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)

Answer / dev

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

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/

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)

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

what is the flat file partition and where have to specify it

1 Answers   TCS,

What is rank transform?

0 Answers  

tell me the push down optimization

2 Answers   Wipro,

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

Can you generate reports in Informatcia?

1 Answers  

difference between shortcut and reusable transformation?

2 Answers  

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

can you use flat file for repository?why?

2 Answers   TCS,

how to join two flat files in informatica?

3 Answers   Wipro,

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers