Answer / sandipana

select rownum as rank,emp_id,sal from(select
lastname,salary from employees orderby salary desc)
where rownum IN(1,3,5);

Answer / priyank

select * from (select rownum rn,emp.* from emp) where mod
(rn,2)=1;

Answer / millar

ie.

select column from table_name where mod(primary_key_column,2)=1;


select employee_id from employees where mod(employee_id,2)=1

Answer / jhansi

It displays odd rows
select * from emp where (rowid,0) in(select rowid,mod
(rownum,2) from emp);

Answer / punyaslok

(select * from emp)-(select rownum,emp.* from emp order by
mod(rownum,2);

Answer / udaya

SELECT * FROM TABLE_NAME WHERE ROWNUM=1 AND ROWNUM=3 AND
ROENUM=5

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

How can you generate reports in informatica?

0 Answers  

what is degenerated dimension table with scenario

2 Answers   HCL,

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,

explain abt union t/r?

1 Answers   IBM,

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,