Answer Posted / nagaraju bhatraju

DECLARE
TYPE v_arr IS VARRAY(25) of NUMBER(3);


v1 v_arr;

v_empno employee.empno%TYPE;

BEGIN

v1(2) := 3;
DBMS_OUTPUT.PUT_LINE('The Value of v1(2) = ' || v1(2));

v_empno := 4;

END;

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2355

---

How to partition the Session?

1105

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1072

---

What is the sql query overwrite in source qualifier in informatica

1076

---

What is informatica?

1143

---

What is meant by active and passive transformation?

1118

---

What is the use of target designer?

1036

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2017

---

 Informatica Checkpoints

3322

---

How to call shell scripts from informatica?

990

---

how to load dimension table and fact table. plz tell me the steps.

2090

---

What is mapping debugger?

1004

---

What is informatica powercenter repository?

1189

---

Explain lookup transformation source types in informatica

1094

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2170

---