Interested to Buy Any Domain ? << Click Here >> for more details...
what is incremental aggregation ,with example?
- 2 Answers
- 9294 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 |
Explain how to import oracle sequence into informatica?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can we integrate different flat file data in a single mapping and with in a single execution
How can you differentiate between powercenter and power map?
What is pmcmd command?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are reusable transformations in how many ways we can create them?
How to generate sequence numbers?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
Can we use parameters of parameter file in presession command
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
Teradata 
