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 convert multiple rows to single row (multiple columns) in informatica
Explain about Informatica server process that how it works relates to mapping variables?
Explain the types of transformations?
What is meant by pre and post session shell command?
What is the function of union transformation?
In which transformation you cannot drag ports into it?
What is meant by a domain?
How do you handle two sessions in Informatica
Explain lookup transformation is active in informatica
In development project what is the process to follow for an etl developer from day1
State the differences between sql override and lookup override?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is the different lookup cache(s)?
Do you find any difficulty while working with flat files as source and target?
Tell me about Propagate functions in informatica