Answer / suraj kedia

Incremental aggregation means applying only the captured
changes in the source to aggregate calculations in a session.
When the source changes only incrementally and if we can
capture those changes,then we can configure the session to
process only those changes.This allows informatica server to
update target table incrementally,rather than forcing it to
process the entire source and recalculate the same
calculations each time you run the session.By doing this
obviously the session performance increases.

Answer / shruthi

When the aggregator transformtaion executes all the output
data will get stored in the temporary location called
aggregator cache. when the next time the mapping runs the
aggreagator transformation runs for the new records loaded
after the first run. These output values will gets
incremented with the values in the aggregator cache. Thia
is called incremental aggregation. By this way we can
improve performance...

Correct me if i was wrong

Answer / lokesh y g

suppose yesterday 100 got inserted into target,today 50
records inserted and 25 records got updateted ,rather then
pulling all records, using incremental logic we can pull
the data only updated records and inserted records using
setmax variable ........

why we are using surogate key in real time give me explanation

2 Answers   TCS,

---

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

---

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

---

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,

---

How can you complete unrcoverable sessions?

1 Answers  

---

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

---

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

what is galaxy repository?

2 Answers  

---

Whats there in global repository

0 Answers  

---

Please let me know how to make Data masking in informatica..

0 Answers  

---