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

What is persistent lookup cache?

1098

---

What are the components of the workflow manager?

1184

---

What is pmcmd command?

1182

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1321

---

What are mapplets?

1328

---

explan ur project architecture?

2128

---

design of staging area?

2076

---

How to extract the informatica rejected data?

1259

---

What is dimensional table?

1133

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2246

---

How many transformations can be used in mapplets.

1983

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1115

---

What is the difference between source qualifier transformations source filter to filter transformation?

1096

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2170

---

What is update strategy transform?

1165

---