Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Advance Thanks,
Manojkumar

Question Posted / manojkumar.challagundla

Answers were Sorted based on User's Feedback



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

Answer / 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

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

In Which scenario did u used Incremental loading?

2 Answers  

What is facttable granularity?

2 Answers  

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

What happens if we dont select data driven option?

2 Answers   Zensar,

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

Can we create multiple integration service on single repository?

0 Answers  

Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

How can you run a session without using server manager?

1 Answers  

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

0 Answers  

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories