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

How can you differentiate between powercenter and power map?

1034

---

Which transformation should we use to normalise the COBOL and relational sources?

1154

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3660

---

Have you worked with/created Parameter file

1625

---

What is the cumulative sum and moving sum?

1154

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1857

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2013

---

What are the databases that informatica can connect to windows?

1012

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1008

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1129

---

How to handle decimal places while importing a flatfile into informatica?

1147

---

draw informatica architecture 8.6 ?

3834

---

Differentiate between sessions and batches?

976

---

Where do we use mapping variables in informatica?

1012

---

Which are the different editions of informatica powercenter that are available?

990

---