Answer Posted / srinu

You have to perform the Incremental Aggregation in Session
Properties only.
Ex:-
You Target Table loaded(with Agg Caluclation) 100 Records
on yesterday ,
Now newly you have 50 Records(25 update,25 insert),
To done the Agg calculation for Updated Records ,Insert
Records you need to
Perform Incremental Aggregation.This is simple way to
increase the Performance,
Redusing the time etc.
If you not perform the Incremental Aggregation, you can
do the same thing
In another way.But it’s lenthy.
Any ??? or Corrections,,let me
know ‘Srinu.srinuvas@gmail.com ‘

which one is better performance wise joiner or look up

1086

---

How might one distinguish in the case of mapping is right or not without associating session?

1105

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1975

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2045

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2258

---

Separate from a database, an information bazaar, and an information stockroom?

1084

---

Differentiate between a database and data warehouse?

1141

---

lookup transformation with screenshots

4002

---

Tell me about Propagate functions in informatica

919

---

What is domain and gateway node?

1161

---

What is informatica? Why do we need it?

1092

---

Difference between Data and Index Caches?

1135

---

What are the various types of transformation?

1174

---

What is Index Caches size?

1110

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1089

---