Answer / vali

to improve the session performance we use the session
partitioning.it improves performance by giving multiple
connections to the source and target.

there are five types of partitioning the session
pass through
data base
round robin
key range
hash partitioning..

Answer / g. manthiramoorthy

Partition Types:
1.Database partitioning.
2.Hash auto-keys.
3.Hash user keys.
4.Key range.
5.Pass-through
6.Round-robin.

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

---

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

0 Answers  

---

What is degenerated dimention table?

7 Answers   Patni,

---

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,

---

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

---

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

---

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

---

Differnce between filter and router?

14 Answers   IBM,

---

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   Cognizant, HCL,

---

Quickly characterize reusable change?

0 Answers  

---