1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

following scenario empsal table i want who exist one lakshs
sal above monthwise?
`
empsal

empid monthyear sal
1 jan2008 1000
2 march2009 50000
3 april2009 4000
4 feb2009 100000
5 jul2009 600000
6 dec 2008 90000

Question Posted / dinesh

Answers were Sorted based on User's Feedback



following scenario empsal table i want who exist one lakshs sal above monthwise? ` emps..

Answer / gd

select empid,monthyear from empsal where sal>100000;

Is This Answer Correct ?    11 Yes 2 No

following scenario empsal table i want who exist one lakshs sal above monthwise? ` emps..

Answer / arpan

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

Is This Answer Correct ?    2 Yes 0 No

following scenario empsal table i want who exist one lakshs sal above monthwise? ` emps..

Answer / sweta kedia

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

Is This Answer Correct ?    1 Yes 1 No

following scenario empsal table i want who exist one lakshs sal above monthwise? ` emps..

Answer / sateesh

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

Is This Answer Correct ?    0 Yes 4 No

following scenario empsal table i want who exist one lakshs sal above monthwise? ` emps..

Answer / animesh

Select EMPID from EMPSAl
Group By monthyear
where
sal> 100000

Is This Answer Correct ?    2 Yes 8 No

Post New Answer

More Informatica Interview Questions

Two Default User groups created in the repository are ____ and ______

2 Answers  

why dimenstion tables are denormalized in nature ?

3 Answers  

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

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

1 Answers  

What is meant by query override?

1 Answers  

In which scenario did you used pushdown optimization?

1 Answers  

Define enterprise data warehousing?

1 Answers  

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

explain about unit testing? in real time?

1 Answers   L&T,

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

Implementation methodology

1 Answers  

For more Informatica Interview Questions Click Here
Categories