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

Write the unconnected lookup syntax and how to return more than one column.

1118

---

Explain dynamic target flat file name generation in informatica

1064

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1040

---

How can we create index after completion of load process?

1132

---

write a query to retrieve the latest records from the table sorted by version(scd)

1077

---

How an expression transformation differs from aggregator transformation?

1047

---

In warehouses how many schemas are there?

1081

---

Differentiate between reusable transformation and mapplet.

1105

---

Clarify the aggregator change?

1034

---

What's the layout of parameter file (what does a parameter file contain?)?

2392

---

How identifying bottlenecks in various components of informatica and resolving them?

1141

---

According to his methodology what all you need before you build a datawarehouse

1762

---

How we can create indexes after completing the loan process?

1218

---

How to join three sources using joiner?

1124

---

What is meant by incremental aggregation?

1116

---