What is incremental aggregation and how it is done?
Answer Posted / raghvendra
incremental aggregation performs aggregation on incremented
data..so based on requirements if we can use incremental
aggregation then definately it will improve performance..so
while develop mapping always keep in mind this factor too...
| Is This Answer Correct ? | 7 Yes | 15 No |
Post New Answer View All Answers
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What do you understand by term role-playing dimension?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is union transformation in informatica?
What all are steps in up gradation of Informatica server?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How to extract sap data using informatica? What is abap? What are idocs?
During the running session, output files are created by informatica server. Enlist few of them.
how many types of dimensions are available in informatica?
What are the different ways to implement parallel processing in informatica?
What is meant by target load plan?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to elaborate tracing level?
update strategy transformation in informatica