What is aggregate cache in aggregator transforamtion?
Answer Posted / ravi sadanand
It is place where all the rows entering the Aggregator
Transformation will be placed till the aggregate
calculations like sum,Avg are made.
all the group information will be stored in index files and
row data in data cache.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What can we do to improve the performance of informatica aggregator transformation?
Enterprise data warehouse your projects phase by phase explain?
What is a node in Informatica?
How do you update the records with or without using update strategy?
What are the issues you have faced in your project? How did you overcome those issues?
What is a joiner transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is depict expression change?
Explain the etl program with few examples.
How will the document be delivered to me?
What is fact table? Explain the different kinds of facts.
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
What is the fact table?
How is union transformation utilized?
What is powercenter on grid?