Interested to Buy Any Domain ? << Click Here >> for more details...
how can we perform incremental aggregation?explain with
example?
- 9 Answers
- 23334 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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 ‘
| Is This Answer Correct ? | 12 Yes | 9 No |
Post New Answer View All Answers
How to do unit testing in informatica? How to load data in informatica ?
Write the unconnected lookup syntax and how to return more than one column.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Under which circumstances, informatica server creates reject files?
What is data transformation manager process?
what are the deliverables?in your project?
What are the tuning techniques you applied during your last project
What is rank transformation in informatica
EXL informatica Questions
Explain the different lookup methods used in informatica?
What is rank index in rank transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is Session and Batches?
What is Data Caches size?
What are the prerequisite tasks to achieve the session partition?
