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.

What are connected or unconnected transformations?

0 Answers   Informatica,

---

What is the Hierarchy of DWH?

1 Answers  

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

---

---

How the Informatica Server reads perameter file?

1 Answers  

---

checkout and checkin in informatica 8.6

3 Answers   TCS,

---

What is a difference between complete, stop and abort?

0 Answers  

---

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

1 Answers   SunGard,

---

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

What are the data movement modes in informatcia?

1 Answers  

---