Interested to Buy Any Domain ? << Click Here >> for more details...
What is incremental aggregation and how it is done?
- 8 Answers
- 38422 Views
- JPMorgan Chase, TCS, I also Faced
- E-Mail Answers
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
Can we create a node as a gateway node and the same node can be assigned to a grid?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How to do the error handling of if ur source is flatfiles?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is the difference between stop and abort in informatica
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How does the aggregator transformation handle null values?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the differences between a connected lookup and unconnected lookup?
Can we create two repositories on same database instance in oracle?
What is the difference between a connected look up and unconnected lookup?
Explain lookup transformation is active in informatica
Explain constraint based loading in informatica
Describe an informatica powercenter?
