Answer Posted / naveen

Answer #3 is correct by Nag.

Addition to above second query for duplicate records, will
return unique records for each duplicate records.

if you need all duplicates records thn follow the below
query.

select * from emp
where empno in (select empno from emp group by empno having
count(empno)>1)


Regards,
Naveen

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

2087

---

Explain about cumulative Sum or moving sum?

1093

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2110

---

Does an informatica transformation support only aggregate expressions?

1088

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1231

---

How to load a Dimension ? and how to load a fact table?

1465

---

can anyone suggest best free Talend data integration training online

1745

---

Mention a few design and development best practices for informatica?

1045

---

wf dont have integration severances how you can run?

1988

---

How might one distinguish in the case of mapping is right or not without associating session?

1197

---

What are the different components of powercenter?

1114

---

How do you promote a non-reusable transformation to reusable transformation?

1180

---

difference between repository database and repository service?

1224

---

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

1957

---

How to update a particular record in target with out running whole workflow?

1629

---