Answer Posted / babu

Hi,
SELECT DISTINCT(DEPTNO) UNIQ,E.DUP FROM EMP
LEFT OUTER JOIN
(SELECT DEPTNO DUP FROM EMP GROUP BY DEPTNO HAVING COUNT
(DEPTNO)>1) E
ON (EMP.DEPTNO=E.DUP)

please correct me if any thing wrong.

Thanks,
Babu

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2186

---

Reusable transformation and shortcut differences

1842

---

How to start a workflow using pmcmd command?

1256

---

Why is sorter an active transformation?

1130

---

Tell me about MD5 functions in informatica

929

---

Scheduling properties,whats the default (sequential)

1959

---

What are data-driven sessions?

1218

---

what is the size of u r source(like file or table)?

2273

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5679

---

How many transformations can be used in mapplets.

1937

---

What is the Process to creating lookup transformation in informatica

1046

---

Mention some types of transformation?

1048

---

What are the designer tools for creating transformations?

1119

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2134

---

How to do unit testing in informatica?

1177

---