Interested to Buy Any Domain ? << Click Here >> for more details...
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
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the informatica performance improvement tips
What are the performance considerations when working with aggregator transformation?
draw informatica architecture 8.6 ?
What is a node in Informatica?
What is the function of look up transformation?
What is parallel processing in informatica?
How to generate sequence numbers?
What is sequence generator transformation in informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What the difference is between a database, a data warehouse and a data mart?
Name the different lookup cache(s)?
r u done any partitions in ur project?
What are the types of lookup transformation?
