Answer / 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 are the advantages of using informatica as an etl tool over teradata?

0 Answers  

---

How to delete the data in the target table after loaded.

3 Answers   TCS,

---

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,

---

How to load relational source into file target?

3 Answers   IBM,

---

What are the popular informatica products?

0 Answers  

---

---

what happens when a batch fails?

3 Answers  

---

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

---

What is predefined event?

1 Answers  

---

Differentiate between router and filter transformation?

0 Answers  

---

what are the perameter and variable?

3 Answers   IBM,

---

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

---

What is workflow? What are the components of workflow manager?

0 Answers  

---