Answer Posted / 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.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What do think which one is the better joiner or look up?
What is option by which we can run all the sessions in a batch simultaneously?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what is size of u r database?
What is the reusable transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
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 do mean by local and global repository?
Explain in detail about scd type 1 through mapping.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain sessions?
What is the use of target designer?
Briefly describe lookup transformation?
How to load a Dimension ? and how to load a fact table?
