Answer / Siddharth Mansaram Badwaik

Incremental aggregation in Informatica refers to the process of updating aggregate values for a given time period or set of records, rather than recomputing all the aggregates from scratch. This approach reduces the processing time and improves performance when dealing with large datasets by only focusing on the new or updated data since the last aggregation run.

Do you find any difficulty while working with flat files as source and target?

1 Answers  

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

---

Is informatica power center designer has 64 bit support?

1 Answers  

---

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

---

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

---

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,

---

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  

---

Does an informatica transformation support only aggregate expressions?

1 Answers  

---

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

---

How many repositories can be created in informatica?

1 Answers  

---

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  

---