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 a shortcut and copy in Informatica and how two are different with each other?
Explain about Informatica server process that how it works relates to mapping variables?
What are the differences between oltp and olap?
How would you join a node to the already existing domain?
What do think which one is the better joiner or look up?
Which development components of informatica have the highest usage?
What are the prerequisite tasks to achieve the session partition?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is complex mapping?
What is substr in informatica?
What is a connected transformation?
What is a sequence generator transformation?
How can you define user defied event?
What you know about transaction control transformation?