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.

How can you access the remote source into your session?

1 Answers  

---

what is upstream and downstream transformation?

7 Answers  

---

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

---

What are session parameters ? How do you set them?

0 Answers  

---

In how many ways we can create ports?

0 Answers  

---

---

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

---

Which kind of index is preferred in DWH?

2 Answers  

---

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   Cognizant, HCL,

---

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

---

How to update a particular record in target with out running whole workflow?

0 Answers  

---

In a sequential batch can u run the session if previous session fails?

3 Answers  

---

Explain what is informatica metadata and where is it stored?

0 Answers  

---