how can we perform incremental aggregation?explain with
example?

Answer Posted / appireddy

Its a session option. when the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incrementaly. for performance we will use it.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we use batches?

601


How do you convert single row from source into three rows into target?

602


can u any challenge your project?

1602


Enterprise data warehouse your projects phase by phase explain?

1459


What are the differences between a connected lookup and unconnected lookup?

644






Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

781


Explain the pipeline partition with real time example?

650


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3320


Explain the different kinds of facts.

561


Explain target update override in informatica

629


What is the procedure for creating independent data marts from informatica 7.1?

563


What are the differences between source qualifier and joiner transformation?

595


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1641


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1585


In warehouses how many schemas are there?

582