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 do mean by local and global repository?

1167

---

Explain lookup transformation is active in informatica

1044

---

Explain the mapping variable usage example in informatica

1094

---

What is update strategy transform?

1033

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1816

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1199

---

Mention some types of transformation?

1002

---

Where are the source flat files kept before running the session?

1024

---

What is informatica metadata and where is it stored?

944

---

Explain what transformation and how many are there in informatica?

899

---

To import the flat file definition into the designer where should the flat file be placed?

1016

---

What are the differences between joiner transformation and source qualifier transformation?

1106

---

what is the size of your data warehousing?

2053

---

whats the logic to load the lower level of granularity of data to fact table.

2217

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4688

---