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)

What are the options in the target session of update strategy transsformatioin?

2 Answers  

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

---

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

---

what is mapping parameter?

2 Answers   Cap Gemini,

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,

---

Briefly describe lookup transformation?

0 Answers  

---

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

---

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,

---

What is the function of aggregator transformation?

0 Answers  

---

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

0 Answers  

---