What is incremental aggregation and how it is done?
Answer Posted / 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 |
Post New Answer View All Answers
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
update strategy transformation in informatica
What do you mean by channel change?
Write the advantages of partitioning a session?
Design a mapping to load the cumulative sum of salaries of employees into target table?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How you know when to use a static cache and dynamic cache in lookup transformation?
How to generate sequence numbers?
How to call shell scripts from informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is rank transformation?
What could be the possible resons of locks by user?
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. ?
On which transformations you created partitions in your project?