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 is a shortcut and copy in Informatica and how two are different with each other?

1160

---

What do you understand by term role-playing dimension?

1006

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2372

---

What is the difference between Active and Passive transformation?

1099

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2218

---

How many number of sessions can one group in batches?

1118

---

What is different between the data warehouse and data mart?

1018

---

Explain pmcmd command usage in informatica

1085

---

What is meant by a domain?

1096

---

What are the types of caches in lookup?

994

---

What are the types of presistent cache in look up tr.

2028

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

978

---

Define pmcmd command?

1010

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1245

---

Target increases every day even though no new record was inserted

1529

---