Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  

What is the difference between a router and a filter transformation?

1 Answers   TCS,

scd methodology?

2 Answers  

What is the need of etl tools?

0 Answers  

What is meta data and system catalog?

2 Answers  

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

Can we create multiple integration service on single repository?

0 Answers  

Can you copy the batches?

3 Answers  

In warehouses how many schemas are there?

0 Answers  

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

What is sorter transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories