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
What is the difference between a connected look up and unconnected lookup?
What are the prerequisite tasks to achieve the session partition?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the types of caches in lookup?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How many numbers of sessions can one group in batches?
What is the Process to creating lookup transformation in informatica
difference between repository database and repository service?
What are the informatica performance improvement tips
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Define filter transformation?
Where do we use mapping variables in informatica?
Repository user profiles
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How can you define user defied event?