Interested to Buy Any Domain ? << Click Here >> for more details...
What is incremental aggregation and how it is done?
- 8 Answers
- 38548 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 |
Different qualification between a related rotate toward the sky and isolates look upward?
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
Explain incremental aggregation in informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Is it possible to use a client with different version than that of its Informatica server?
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
what is the difference between static and dynamic
8.what is mapplet ?give example?
How we can confirm all mappings in the repository simultaneously?
How do you implement unconn. Stored proc. In a mapping?
How to load time dimension?
Teradata 
