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
Whats the difference between informatica powercenter server, repositoryserver and repository?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Write the program through which the records can be updated?
What is the session task and command task?
Explain the use of aggregator cache file?
What is option by which we can run all the sessions in a batch simultaneously?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the types of caches in lookup?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is flashback table ? Advance thanks
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How can informatica be used for an organization?
Which transformation should we use to normalise the COBOL and relational sources?