Interested to Buy Any Domain ? << Click Here >> for more details...
What is incremental aggregation and how it is done?
- 8 Answers
- 38442 Views
- JPMorgan Chase, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 21 Yes | 2 No |
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.
| Is This Answer Correct ? | 15 Yes | 13 No |
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.
| Is This Answer Correct ? | 11 Yes | 9 No |
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..
| Is This Answer Correct ? | 2 Yes | 1 No |
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/
| Is This Answer Correct ? | 1 Yes | 0 No |
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
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / siva
If we choose Incremental Aggregation Informatica will store the cache files permanently.
| Is This Answer Correct ? | 1 Yes | 1 No |
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...
| Is This Answer Correct ? | 7 Yes | 15 No |
What is flashback table ? Advance thanks
Enterprise data warehouse your projects phase by phase explain?
what is the logic will you implement to load data into a fact table from n dimension tables?
in which situations do u go for snowflake schema ?
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
how remove 1st 3 records & last 3 records in informatics
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
why u go for dimensions ?
Teradata 
