when we dont use aggregator in mapping ?
Answers were Sorted based on User's Feedback
Aggregator transformation is used to calculate values in a
group. It is the only t/r which can be used for aggregate
calculations e.g: Sum,avg,max,min,count....
So when we don't need any such aggregate calculations, than
we don't use aggregator transformation.
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / vikram
when thre are no group by or any other calculations required
Is This Answer Correct ? | 9 Yes | 1 No |
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
What is an expression transformation?
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
How can you differentiate between powercenter and power map?
How to load time dimension?
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
How many repositories can be created in informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
What is dimensional table?
How can we use mapping variables in informatica?
Explain how many types of dimensions are available in informatica?