Whether Aggrigator transformation ignore the null values or
consider the null values ?
Advance Thanks,
Manojkumar
Answer Posted / jey.dgl
Yes. Aggregator transformation ignore the null values and In Oracle also ignore the null values.
If u want to ignore the null values, use isnull() function to avoid null values
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the different lookup cache(s)?
What is a filter transformation and why it is an active one?
What is data movement mode in Informatica and difference between them?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is blocking transformation?
What are mapplets? How is it different from a Reusable Transformation?
What does refresh system mean, and what are its distinctive choice?
When do you use sql override in a lookup transformation?
Please let me know how to make Data masking in informatica..
How to Create a folder using pmrep command?
What are the different transaction levels available in transaction control transformation?
Explain the different dimensions.
What is persistent lookup cache?
What is rank transform?
What are the new features of Power Center 5.0?