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.

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

0 Answers  

---

What is dynamic cache?

0 Answers  

---

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

---

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  

---

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

---

---

Global and Local shortcuts. Advantages.

0 Answers  

---

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

---

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

7 Answers   iNautix,

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

---