Answer / madhu

this is can acheieve by following query

select * from(select rowunum r,e.*from emp e) where
r>(select count(*)-5 from emp);

Answer / priyank

select * from emp
minus
select * from emp where rownum <= (select max(rownum)-5
from emp)

how to load rows into fact table in data warehouse

0 Answers   Informatica,

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

What are the differences between oltp and olap?

0 Answers  

---

Kimball and Inmon methodologies?

2 Answers  

---

What are the static cache and dynamic cache in informatica?

0 Answers  

---

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

---

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

6 Answers  

---

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,

---

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

---