Answer / gd

select empid,monthyear from empsal where sal>100000;

Answer / arpan

Select empid,monthyear,sal from empsal
where sal>100000
orderby monthyear;

Answer / sweta kedia

Select EMPID from EMPSAL Where MONTHYEAR IN(SELECT monthyear
from empsal
Group By monthyear
where
sal> 100000)

Answer / sateesh

select * from empsal GROUPBY ‘monthyear’
HAVING sal>=100000.

Answer / animesh

Select EMPID from EMPSAl
Group By monthyear
where
sal> 100000

How can you define user defied event?

0 Answers  

---

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

0 Answers  

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

Make a note of the quantity vaults made in informatica?

0 Answers  

---

can we use cartesian join in informatica

3 Answers   IBM,

---

---

What is difference between a gateway node and worker node?

0 Answers  

---

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

---

In warehouses how many schemas are there?

0 Answers  

---

What all are steps in up gradation of Informatica server?

0 Answers  

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,

---