what is incremental aggregation ,with example?
- 2 Answers
- 8260 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Incremental aggregation is nothing but a method of maintaing
new records in the target when we use an aggregator in our
mapping..
With incremental aggregation only those records which are
new in the source are processed in the mapping excluding
those which have been processed.
The data which was earlier present in the source n has been
processed is stored in the cache and the new records are
processed along with them.
For this we need to select the option INCREMENTAL
AGGREGATION from session properties.
| Is This Answer Correct ? | 2 Yes | 0 No |
Before doing incremental aggregation u need to know incremental load, source data should be loaded incrementally, place a aggregator transformation group the ports on your requirement,like sales date then write your aggregate functions like max, min, sum, avg etc.. then check the property of incremental aggregation in session make sure the target table should have a primary key if it is relational then run the workflow... then u get the inital values pass a new record to the source and run the workflow.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can you use flat files in Mapplets.
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
Can we change Dynamic to Static or Persistent cache? If so what happens?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is the gap analysis?
What are the disadvantages of Sequence Generator T/R?
What is a surrogate key?Why we use it in a mapping?Pl give an example.
what are the settiings that u use to cofigure the joiner transformation?
What is difference between maplet and reusable transformation?
Why do we need informatica?
what happens if you try to create a shortcut to a non- shared folder?
What are the designer tools for creating transformations?
Teradata 
