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 are mapplets?

1271

---

Define mapping and session?

1033

---

What is session task and command task?

1296

---

lookup transformation with screenshots

4006

---

What is repository manager?

988

---

State the differences between sql override and lookup override?

1208

---

What is the function of look up transformation?

1123

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

---

How do you use reject loader.

2603

---

What are the types of schemas we have in data warehouse and what are the difference between them?

941

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2003

---

Which version configuration tool used in ur project?

3258

---

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.

1995

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2193

---

Explain pmcmd command usage in informatica

1132

---