Answer Posted / maxy

I think it's better to have a null check here in the exp
before aggregating.
If salary is Null for any employee it will not be consider
while caculating the avg.
ex-
epm sal
e1 10
e2 20
e3
e4 30

Though there are four employee avg will be 20.

How do you convert single row from source into three rows into target?

1213

---

What is a pre-defined event and user-defined event?

1082

---

Enlist some properties of sessions.

1135

---

Repository user profiles

1811

---

What is intricate mapping?

1312

---

Please let me know how to make Data masking in informatica..

1773

---

Can anyone tell me the new features in Informatica 9 Version?

2207

---

What is meant by pre and post session shell command?

1200

---

Explain about Informatica server process that how it works relates to mapping variables?

1128

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1128

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1113

---

Explain the difference between mapping parameter and mapping variable?

1083

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1315

---

what is song in infrmatica...?

2320

---

What can we do to improve the performance of informatica aggregator transformation?

1143

---