Answer / eswar

When using incremental aggregation, you apply captured
changes in the source to aggregate calculations in a
session. If the source changes only incrementally and you
can capture changes, you can configure the session to
process only those changes. This allows the Informatica
Server to update your target incrementally, rather than
forcing it to process the entire source and recalculate the
same calculations each time you run the session.

Answer / sivaprasad

Gradually to synchronize the target data with source data,
there are further 2 techniques:-
Refresh load - Where the existing data is truncated and
reloaded completely.
Incremental - Where delta or difference between target and
source data is dumped at regular intervals. Timsetamp for
previous delta load has to be maintained.

Answer / bharat

Incremental aggregation is a technique by which we can
capture the aggregated data incrementally.
for this we have to sort the data before sending it to
aggregator then we have to enable the property incremental
aggregation in the workflow level inside the session.

Answer / rams

using incrimental aggrigation in session level,we calculate the only capture changes data in source,This allows the Informatica Server to update your target incrementally..

Answer / ankit kansal

Incremental Aggregation ->

Incremental Aggregation is a technique to populate data on your aggregated tables or materialized view incrementally.

It takes new incoming data only based upon last updated column value or created_date time stamp column and thus uses its own cache created/updated earlier and updated the table as required.

http://deepinopensource.blogspot.in/

Answer / vas chiky

If suppose, i use a dynamic lookup of target agg table and
an update stategy to update or insert records.. what is the
difference between this and Incremental aggregation ?? why
i need to depend on this Incremental aggregation chk box??

please clear my doubt

Answer / siva

If we choose Incremental Aggregation Informatica will store the cache files permanently.

Answer / raghvendra

incremental aggregation performs aggregation on incremented
data..so based on requirements if we can use incremental
aggregation then definately it will improve performance..so
while develop mapping always keep in mind this factor too...

normalizer transformation

3 Answers   CTS,

How to load time dimension?

1 Answers   Ford,

What is parallel processing in informatica?

0 Answers  

How to extract sap data using informatica?

0 Answers  

Explain the different dimensions.

0 Answers  

What are Target Options on the Servers?

1 Answers  

What is incremental aggregation?

0 Answers  

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

In dimension and fact table? which one holds big data?

2 Answers  

What is the difference between a connected look up and unconnected lookup?

0 Answers  

What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  

How do you load first and last records into target table?

0 Answers