Whether Aggrigator transformation ignore the null values or
consider the null values ?
Advance Thanks,
Manojkumar
- 3 Answers
- 8222 Views
- IBM, I also Faced
- E-Mail Answers
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
lookup transformation with screenshots
What are the features of complex mapping?
can we override a native sql query within informatica? Where do we do it?
Clarify the utilization of aggregator cache record?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is domain and gateway node?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
State the differences between sql override and lookup override?
Is there any target staging area in informatica not staging area
How can we handle two sessions in informatica?
How is union transformation utilized?
tell me the rules and responsblites in our project(my project is development)
How we can use union transformation?
What are the new features of informatica 9.x developer?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
