Whether Aggrigator transformation ignore the null values or consider the null

Whether Aggrigator transformation ignore the null values or
consider the null values ?

Advance Thanks,
Manojkumar

Question Posted / manojkumar.challagundla

3 Answers
8993 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance ..

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

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance ..

Answer / ankur saini er.ankur861@gmail.

yes aggregator ignore null values but joined consider
them...

Is This Answer Correct ?

1 Yes

0 No

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance ..

Answer / manojkumar

Thanks Jey.

Is This Answer Correct ?

1 Yes

3 No

Post New Answer

More Informatica Interview Questions

What is confirmed dimension and fact?

7 Answers

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers Wipro,

can anyone suggest best free Talend data integration training online

0 Answers

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers CTS,

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers IBM,

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers CTS,

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers NTT Data,

How to generate sequence numbers using expression transformation?

0 Answers Informatica,

For more Informatica Interview Questions Click Here