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;

Briefly describe lookup transformation?

982

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1026

---

What is blocking transformation?

1084

---

What is the format of informatica objects in a repository?

976

---

Describe an informatica powercenter?

1038

---

What do you understand by a term domain?

1063

---

What are the restrictions of union transformation?

978

---

What is a code page?

1118

---

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

1070

---

How to start a workflow using pmcmd command?

1178

---

How does the aggregator transformation handle null values?

1087

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1039

---

Performance tuning in UNIX for informatica mappings?

2508

---

What is sequence generator transformation in informatica?

997

---

What is depict expression change?

1033

---