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)

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

---

How to elaborate tracing level?

0 Answers  

---

In joiner, how to load Master table in Target?

2 Answers  

---

How we can create indexes after completing the load process?

0 Answers  

---

How can you access the remote source into your session?

1 Answers  

---

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,

---

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

What are the new features of informatica 9.x developer?

0 Answers  

---

what is the dashbords?

1 Answers   IBM,

---

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

---