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 # 130732

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 8387

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

 5 Informatica 6830

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 13426

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

TCS,

1 Informatica 6308

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

 2 Informatica 12062

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 9790

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

Flextronics,

5 Informatica 9840

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

TCS,

2 Informatica 7344

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 5999

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 7907

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

iNautix,

7 Informatica 19660

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 5809

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

TCS,

2 Informatica 17370



Answers / { jeyakumar }

Question { IBM, 7695 }

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