Answer Posted / naveen kumar
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 |
Post New Answer View All Answers
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are mapplets? How is it different from a Reusable Transformation?
Enlist few areas or real-time situations where informatica is required.
What is joiner transformation?
What are the databases that informatica can connect to windows?
Sequence generator, when you move from develoment to production how will you reset
Explain constraint based loading in informatica
What is a node in Informatica?
Separate from an archive server and a powerhouse?
what is SDLC way of code development?
What are the new features of informatica 9.x at the developer level?
How might you approve all mappings in the archive all the while?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is a filter transformation?
How to call shell scripts from informatica?