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
8839 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 are the challenges you have faced in your project?

1 Answers Cognizant, Infosys,

what is data driven in update strategy transformation?

2 Answers HCL, PayPal,

What is expression transformation?

0 Answers

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers

What are the new features of Power Center 5.0?

0 Answers

What is different between informatica version 8 and 9 version

1 Answers Cognizant, IBM,

Explain pushdown optimization and types in informatica

0 Answers Informatica,

What are the different tools in workflow manager?

1 Answers

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers HCL,

Can we create out put ports in source qualifier t/r?

5 Answers TCS,

Is there any way to read the ms excel datas directly into informatica?

0 Answers

For more Informatica Interview Questions Click Here