$-This is d symbol for server o inbuilt variable.

$$-this is the symbol for the variables o parameters which v create

Hi,

$ is session parameter e.g $DBConnection
$$ is mapping parameter/variable e.g $$LASTRunDate

Thanks

In session properties use the header option and select header output field name

This is a way in informatica itself, follow the below step

In session level, click Edit - > Mapping - > select the tgt file - > goto Header Option -> select 'Output Filed Names'

We are done... u ll find the header names in the flat file. :)

cheers
Rakesh

This will work for only highest salary n=1 but not work for 2nd and rest nth salary...
Did you have tried this?

Code
 SELECT * FROM  (SELECT employee_id, salary, dense_rank() OVER ( ORDER BY salary DESC)  r 
  FROM employees) a 
  WHERE a.r =3 ;