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

Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers   Wipro,

---

Describe data concatenation?

0 Answers  

---

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

Explain sessions and how many types of sessions are there?

0 Answers  

---

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

---

can we use bulk loading when we use look in mapping

1 Answers   TCS,

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

---

Define error Threshold?

1 Answers  

---

What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  

---

What is joiner change?

0 Answers  

---