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 are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the difference between informatica 7.0 and 8.0?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
explain about unit testing? in real time?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is domain and gateway node?
Explain the difference between mapping parameter and mapping variable?
What is an unconnected transformation?
Briefly describe lookup transformation?
How to join three sources using joiner?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
waht type of interface is used for testing the data in informatica
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain Dataware house architecture .how data flow from intial to end?
Define mapping and session?