jeyakumar


{ City } chennai
< Country > india
* Profession * software engineer
User No # 78191
Total Questions Posted # 13
Total Answers Posted # 1

Total Answers Posted for My Questions # 41
Total Views for My Questions # 130234

Users Marked my Answers as Correct # 4
Users Marked my Answers as Wrong # 1
Questions / { jeyakumar }
Questions Answers Category Views Company eMail

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

TCS,

2 Informatica 8363

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

 5 Informatica 6782

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

TCS,

2 Informatica 13389

What is sql query override? When did u use sql query override?

TCS,

1 Informatica 6279

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

 2 Informatica 12035

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

 5 Informatica 9727

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

Flextronics,

5 Informatica 9790

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

TCS,

2 Informatica 7319

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

iNautix,

1 Informatica 5981

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

iNautix,

5 Informatica 7869

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

iNautix,

7 Informatica 19589

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

 2 Informatica 5779

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

TCS,

2 Informatica 17332



Answers / { jeyakumar }

Question { IBM, 7652 }

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

Advance Thanks,
Manojkumar


Answer

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