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;

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

---

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

---

How do you change parameter when you move it from development to production.

1 Answers  

---

What are the components of the workflow manager?

0 Answers  

---

What is an active transformation?

0 Answers   Informatica,

---

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

---

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

how to connect two or more table with single source qualifier?

4 Answers   IBM,

---

What is target designer and target load order?

0 Answers  

---

what is the flat file partition and where have to specify it

1 Answers   TCS,

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---