Answer / nagaraju bhatraju

A PL/SQL table is a one-dimensional, unbounded, sparse
collection of homogeneous elements, indexed by integers. In
technical terms, it is like an array

Answer / sandeep

From Oracle 8 onwards PLSQL table is an Associative Array

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---

how to insert header after each group.

1 Answers   IBM,

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

What is hash partition?

2 Answers  

---

What is the use of incremental aggregation?

2 Answers  

---

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

Explain your project of banking domian.

0 Answers   Cap Gemini,

---

What do you mean by blocking transformation?

0 Answers  

---

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

---

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

---