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

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

---

in which situations do u go for sequence generator ?

2 Answers   TCS,

---

what is left outer join?

3 Answers   L&T,

---

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

---

---

How does the aggregator transformation handle null values?

0 Answers  

---

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

---

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

---