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
How to delete duplicate row using informatica?
Define filter transformation?
How will the document be delivered to me?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is workflow monitor?
generate date / time dimension in informatica
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is a transaction control transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is fact table? Explain the different kinds of facts.
How to create the source and target database connections in server manager?
How many numbers of sessions can one group in batches?
Which files are created during the session rums by informatics server?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is a router transformation?