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;

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---

explain about unit testing? in real time?

0 Answers   L&T,

---

What is the difference between Normal load and Bulk load?

5 Answers  

---

expain about the tune parameters?

0 Answers   TCS,

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

---

What is galaxy shema

2 Answers   CGI,

---

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers  

---

What are Business Components in Informatica?

1 Answers  

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---