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.

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

---

what is the complex transformation you used in informatica

0 Answers   TCS,

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

How would you copy the content of one repository to another repository?

0 Answers  

---

---

What are the performance considerations when working with aggregator transformation?

0 Answers  

---

What is source qualifier?

6 Answers   SDS,

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

---

What is the difference between stop and abort in informatica

0 Answers   Informatica,

---

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

---

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

---