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
How can we use batches?
How do you convert single row from source into three rows into target?
can u any challenge your project?
Enterprise data warehouse your projects phase by phase explain?
What are the differences between a connected lookup and unconnected lookup?
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.
Explain the pipeline partition with real time example?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Explain the different kinds of facts.
Explain target update override in informatica
What is the procedure for creating independent data marts from informatica 7.1?
What are the differences between source qualifier and joiner transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
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
In warehouses how many schemas are there?