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...

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


Please Help Members By Posting Answers For Below Questions

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1128


What is the difference between informatica 7.0 and 8.0?

1016


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2395


explain about unit testing? in real time?

2205


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)

1628


What is domain and gateway node?

1165


Explain the difference between mapping parameter and mapping variable?

1038


What is an unconnected transformation?

1087


Briefly describe lookup transformation?

1046


How to join three sources using joiner?

1115


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?

2131


waht type of interface is used for testing the data in informatica

2256


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

2121


Explain Dataware house architecture .how data flow from intial to end?

2584


Define mapping and session?

1033