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
What is fact table? Explain the different kinds of facts.
Does an informatica transformation support only aggregate expressions?
Explain incremental aggregation in informatica
Write the unconnected lookup syntax?
What differs when we choose the sorted input for aggregator transformation?
Explain pushdown optimization and types in informatica
As union transformation gives UNION ALL output, how you will get the UNION output?
Which are the different editions of informatica powercenter that are available?
What is the need of an ETL tool?
Design a mapping to load a target table with the following values from the above source?
What are the types of caches in lookup? Explain them.
Is it possible to define a single node as a Gateway node as well as worker node?
whats the logic to load the lower level of granularity of data to fact table.
where to store informatica rejected data?
Which is the t/r that builts only single cache memory?
