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

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

What are session parameters ? How do you set them?

0 Answers  

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

how to remove staging area

1 Answers  

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers  

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,