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 to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

1 Answers   IBM,

---

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

---

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

If informatica has its scheduler why using third party scheduler?

0 Answers  

---

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

---

What is substr in informatica?

0 Answers  

---

How we can use union transformation?

0 Answers  

---

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  

---

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---