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

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

What is the Difference between PowerPlay transformer and power play reports?

1 Answers  

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,

---

in which situations do u go for scds ?

3 Answers   TCS,

---

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

---

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---

Which are the different editions of informatica powercenter that are available?

0 Answers  

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

---