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 an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

Can i create a lookup table without cache.

7 Answers   iGate,

what is the -ve test case in your project.

0 Answers   CTS, TCS,

how can we calculate fact table size?

1 Answers  

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,

explain about unit testing? in real time?

0 Answers   L&T,

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,