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 is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

Differentiate between a repository server and a powerhouse?

0 Answers  

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

what are the limitation of sorter transformation?

2 Answers   TCS,

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

What is the difference between Normal load and Bulk load?

5 Answers  

Is it possible to update the target table with PK?

1 Answers   TCS,

how to connect two or more table with single source qualifier?

4 Answers   IBM,

what is data driven?

1 Answers  

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

What is dimensional table? Explain the different dimensions.

0 Answers