Answer / satya

In addition to Kapil's answer, You can have "push down"
optimization at source database or target database or Full
(Source and target). But before you enable this option you
keep the following things in mind

1. When you are processing long transaction at database
level , The objects will be lock and data base objects are
not available for other operations for long time.

2. It will inturn hampers the datbase concurrency and
increases the chance of "Dead locks" on database

Thanks : Satya

Answer / kapil

The Pushdown Optimization Option improves performance by
enabling processing to be “pushed down” to a
relational database, maximizing fl exibility, minimizing
unnecessary data movement, and providing the optimal
performance for both data-intensive and process-intensive
transformations.

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

---

how do u tune queries?

1 Answers  

---

what is correlated query?

2 Answers   IBM,

---

Explain in detail about scd type 1 through mapping.

0 Answers  

---

What is surrogate key?

9 Answers  

---

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

---

where to select code page option?

2 Answers   TCS,

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

---

What is the cumulative sum and moving sum?

0 Answers  

---

In how many ways we can create ports?

0 Answers  

---

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

---

what type of problem you faced insales project or insurance project

1 Answers   Sony,

---