Answer / shrawan

select employee, salary from table_name
where
salary > ( select avg(salary) from table_name;

Answer / sudheer113

go with this order EXP, AGG, JOINER, FILTER

this will work

Answer / 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.

Answer / shaik

Source--->EXP--->AGG--->Filter--->Target

by using agg T/f you can find the avg,use that value ti
filter the values by using filter transformation..............

How many cubes create from a single model?

1 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

---

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  

---

what is mystery dimension?

1 Answers  

---

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

---

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

---

Design a mapping to get year of join for each employee.

4 Answers   Accenture,

---

How to recover the standalone session?

2 Answers  

---

What is the difference between view and materialised view?

6 Answers  

---