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

Answer / ankur saini er.ankur861@gmail.

yes aggregator ignore null values but joined consider
them...

Answer / manojkumar

Thanks Jey.

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

How an expression transformation differs from aggregator transformation?

0 Answers  

---

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

---

What are the different components of powercenter?

0 Answers  

---

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,

---

How to improve the session performance in informatica?

3 Answers   Accenture,

---

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

How do you recover rows from a failed session

1 Answers  

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

What is meta data and system catalog?

2 Answers  

---

In Which scenario did u used Incremental loading?

2 Answers  

---