Answer / babu

Hi,
Mapping:

SRC==>EXP==>AGGR==>UNION
|==>TRG
SRC==>

EXP:In first DFD we have EXPR and AGGr,in EXPR we have to
take one output port with a constant value by using that
output port calculate the sum sal in AGGR.In AGGR take one
output port that as name field with constant value(total)
and the sum sal field as sal after that UNION trns is there
union the two DFD's,finally we get the what we expect.

Answer / kulasekhar reddy tholeti

Try it 100% you will get answer.

Select name,no from source
union
select "total",sum(sal) from source;

Answer / chinthi

actually i need total as new record value as 10000

Answer / babu

Hi Chinthi
You will do the above mapping,definely you can get
whatever you want.


Please check and intimate in case of any issues.

dwarak.vbr@gmail.com

difference between shortcut and reusable transformation?

2 Answers  

---

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

1 Answers   TCS,

---

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

---

What is confirmed dimension?

3 Answers  

---

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

---

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

If informatica has its scheduler why using third party scheduler?

0 Answers  

---

What are multi-group transformations?

0 Answers   Informatica,

---

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

---

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  

---

In any project how many mappings they will use(minimum)?

1 Answers  

---