Answer / Lal Bahadur Kumar

Pushdown Optimization in Informatica is a technique that pushes data processing tasks to the database server instead of the PowerCenter Engine. This reduces the amount of data sent between the database and PowerCenter, improving performance. There are two types of pushdown optimization: SQL Pushdown and Expression Pushdown.

What is dynamic cache?

1 Answers  

---

Explain what is informatica metadata and where is it stored?

1 Answers  

---

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

---

What are the static cache and dynamic cache in informatica?

1 Answers  

---

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

---

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

---

what is upstream and downstream transformation?

7 Answers  

---

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,

---

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

---

What are session parameters ? How do you set them?

1 Answers  

---

How will you convert rows into columns or columns into rows

1 Answers  

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---