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)

&#61656; Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

---

What all are steps in up gradation of Informatica server?

0 Answers  

---

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

---

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

---

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

---

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

---

What is log file,and where is it located,why u r using the log file

1 Answers   TCS,

---

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

---