Answer Posted / sasmita panda

session performance in aggregator T/R can be increased by
aggregation cache i.e through increamental aggregation.
Aggregation cache has tow caches i)index ii) data.

For first run it performs aggregation calculation in
aggregation cache.Index cache contains group by port
values.Data cache will contain if any variable ports are
created and output port on which we want to implement
aggregate function.

Rowid of last record which is participated in Agg. T/R will
be saved in repository.

During second run it finds the rowid of last record then it
performs increamental aggregation.The integration service
will check the historical information in the index cache
file for corresponding group.If it finds it performs
aggregation operation increamentally. If not finds then it
will adda new port for aggreagtion.

How do we call shell scripts from informatica?

1120

---

can you please explain me pre session and post session options?

7566

---

What is the cumulative sum and moving sum?

1186

---

How to extract sap data using informatica?

1042

---

How to Create a folder using pmrep command?

1174

---

Could you explain what is enterprise data warehouse?

1148

---

What is meant by incremental aggregation?

1106

---

What is native users?

1163

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

---

What is meant by lookup transformation?

1110

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1167

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2271

---

What is the different lookup cache(s)?

1086

---

What differs when we choose the sorted input for aggregator transformation?

1024

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1282

---