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

What is union transformation in informatica?

1096

---

What do you mean by worklet?

1014

---

How can we use mapping variables in informatica?

999

---

without table how to come first record only in oracle?

2199

---

What if the source is a flat-file?

1039

---

How can we delete duplicate rows from flat files?

1159

---

What are the advantages of using informatica as an etl tool over teradata?

968

---

On which transformations you created partitions in your project?

1247

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1941

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1009

---

What is an aggregator transformation?

1025

---

Explain the scenario which compels informatica server to reject files?

1083

---

What is decode in static cache?

1073

---

Define mapping and session?

966

---

How does a rank transform differ from aggregator transform functions max and min?

1139

---