Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 11660 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
What is up date strategy and what are the options for update strategy?
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
Enlist few areas or real-time situations where informatica is required.
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
What is the function of look up transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Define update strategy?
Explain in detail scd type 2 through mapping.
How to eliminate 1st and last rows from the source and load the inbetween rows.
Teradata 
