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

Whats the difference between informatica powercenter server, repositoryserver and repository?

1104


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1923


Write the program through which the records can be updated?

933


What is the session task and command task?

986


Explain the use of aggregator cache file?

1186


What is option by which we can run all the sessions in a batch simultaneously?

1077


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6908


What are the types of caches in lookup?

974


Explain pushdown optimization $pushdownconfig parameter - informatica

1078


What is flashback table ? Advance thanks

1870


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1850


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6037


if we have a delimiters at unwanted places in a flat file how can we over come those.

1984


How can informatica be used for an organization?

1128


Which transformation should we use to normalise the COBOL and relational sources?

1139