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 fact table?

0 Answers  

What are the challenges of Dataware housing in the future?

2 Answers   HP,

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

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

4 Answers   DELL, IBM, Lehman Brothers,

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,

why we use datawarehouse

0 Answers   HCL,

Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,

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

0 Answers  

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,

List the transformation in informatica.

1 Answers   TCS,

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,

What is a filter transformation?

0 Answers