what is the difference between a session and a task?

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 8th, 2008

Seesions : Set of instructions to run a mappingTask: session is type of task. other than that informatica several type of task like Assignment,Command,Control,Decision,Email,Event-Raise,Event-Wait,Timer,session

ravi214u

 Profile Answers by ravi214u Questions by ravi214u

• Dec 11th, 2007

Session:- Containts no of mappings.Tasks:- No of session.

Answer Question  Select Best Answer

katgeektalk

 Profile Answers by katgeektalk Questions by katgeektalk

• Aug 26th, 2010

Select hiredate,  to_char(hiredate, 'Day')  "DAY OF THE WEEK"from scott.emporder by to_char(hiredate-1, 'D')

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• Mar 22nd, 2010

Select to_char(hire_date, 'day')from table_nameorder by to_char(hire_date -1 ,'day');RegardsDharmendra Jaiswal

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

maverickwild  

 Profile Answers by maverickwild Questions by maverickwild

• Member Since Nov-2005 | Nov 15th, 2005

---

Try this

select sal from (select * from order by sal asc) where rownum < 3

snehal Falke

• Jul 13th, 2012

Select * FROM emp ORDER BY sal ASC LIMIT 2

mohit

• Jun 28th, 2012

If you want to employee name then query is given below

Code
SELECT ename,sal FROM (SELECT * FROM emp ORDER BY sal ASC)
WHERE rownum<=2;

Improve Answer