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 do you understand by term role-playing dimension?

1058

---

How to differentiate between the active and passive transformations?

1176

---

Is it possible to use a client with different version than that of its Informatica server?

1155

---

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

1093

---

Explain lookup transformation in informatica

1081

---

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

1118

---

Is it possible to create multiple domains on a single Informatica server?

1251

---

design of staging area?

2034

---

What are the measure objects?

1213

---

Is stop and abort are same in informatica?

1010

---

is it possible to index the data in cache of lkp transformation ?

2033

---

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

1077

---

State the differences between sql override and lookup override?

1218

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2019

---

In development project what is the process to follow for an etl developer from day1

1727

---