Answer Posted / amedela chandra sekhar

Select * from(select rownum as rno,emp.* from emp) where rno=&n
EX:

SQL> Select * from(select rownum as rno,emp.* from emp) where rno=&n;
Enter value for n: 1
old 1: Select * from(select rownum as rno,emp.* from emp) where rno=&n
new 1: Select * from(select rownum as rno,emp.* from emp) where rno=1

RNO EMPNO ENAME JOB MGR HIREDATE SAL
---------- ---------- ---------- --------- ---------- --------- ----------
COMM DEPTNO
---------- ----------
1 7369 SMITH CLERK 7902 17-DEC-80 800
20

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2058

---

What does update strategy mean, and what are the different option of it?

1038

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1038

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1928

---

Explain about cumulative Sum or moving sum?

983

---

How to update or delete the rows in a target, which do not have key fields?

1121

---

How to load the data from people soft hrm to people soft erm using informatica?

952

---

Is it possible to revert a global repository to local one and why?

1026

---

Differentiate between source qualifier and filter transformation?

1510

---

Separate from a database, an information bazaar, and an information stockroom?

1014

---

explain abt ur project architecture?

2124

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1026

---

What does refresh system mean, and what are its distinctive choice?

1075

---

How many types of sessions are there in informatica.please explain them?

1113

---

State the differences between sql override and lookup override?

1114

---