Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is the need of an ETL tool?

0 Answers   Informatica,

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

How do you load first and last records into target table?

0 Answers  

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

What are the reusable transforamtions?

2 Answers  

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

How do you migrate data from one environment to another?

0 Answers  

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

What are the joiner caches?

3 Answers   Informatica,

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

What will be the approach?

0 Answers  

For more Informatica Interview Questions Click Here
Categories