Interested to Buy Any Domain ? << Click Here >> for more details...
how can we perform incremental aggregation?explain with
example?
- 9 Answers
- 23597 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 generate sequence numbers without using the sequence generator transformation?
What is the use of transformation?
Define enterprise data warehousing?
What do you understand by SOA of Informatica?
What are the types of caches in lookup? Explain them.
What all are steps in up gradation of Informatica server?
What is the difference between writing a joiner query in ANSI style and THETA style?
difference between repository database and repository service?
What is a shortcut and copy in Informatica and how two are different with each other?
Tell me about MD5 functions in informatica
Explain lookup transformation in informatica
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Design a mapping to load a target table with the following values from the above source?
whats the logic to load the lower level of granularity of data to fact table.
