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

What are the two modes of datamovement in informatica sever?

2 Answers  

Explain scd type 3 through mapping.

0 Answers  

generate date / time dimension in informatica

0 Answers   Informatica,

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

what is distinct

4 Answers  

Differnce between filter and router?

14 Answers   IBM,

tell me about your project functionality

0 Answers  

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

How to update a particular record in target with out running whole workflow?

0 Answers  

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

What is exclusive and normal mode for repository services?

0 Answers  

explain different levels in pushdown optimization with example?

2 Answers   TCS,