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 predefined event?
What are the modules in Power Center
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the reusable transformations?
Is there any target staging area in informatica not staging area
What is the procedure for creating independent data marts from informatica 7.1?
What is data caches/ index caches?
Write the unconnected lookup syntax?
What are the designer tools for creating transformations?
What is the different lookup cache(s)?
What are the static cache and dynamic cache in informatica?
Why do we need informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Differentiate between reusable transformation and mapplet.
can anyone explain me about retail domain project in informatica?