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;

Global and Local shortcuts. Advantages.

1952

---

Explain informatica architecture - version 8 / 9

1018

---

Design a mapping to load a target table with the following values from the above source?

1281

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5676

---

How an expression transformation differs from aggregator transformation?

988

---

What all join we can perform in LOOKUP transformation?

911

---

Why filter transformation is an active one?

928

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1009

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

981

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2466

---

without table how to come first record only in oracle?

2199

---

What are the settings that you use to configure the joiner transformation?

996

---

What are the different types of olap? Give an example?

971

---

What is meant by lookup transformation? Explain the types of lookup transformation?

894

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1015

---