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 to load time dimension?

1 Answers   Ford,

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

Mention some types of transformation?

0 Answers  

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  

what is dimension table?

17 Answers  

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

What is the Router transformation?

2 Answers   Informatica,

What is the function of aggregator transformation?

0 Answers  

Differentiate between joiner and lookup transformation?

0 Answers  

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,

How we can use union transformation?

0 Answers  

What is sorter transformation?

0 Answers