Answer Posted / srik

5m => 5 million recors.

1) Since target side records are very huge compared to
the source, caching is not preffred. so No caching.

2) Again with no caching we can accomplsh this in 2 ways
a) By Joiner
b) Unconnected lookup
but as unconnected lookup is not in answers is in the
option, Joiner is the answer

What is the reusable transformation?

1053

---

What is meant by active and passive transformation?

1131

---

How to elaborate tracing level?

1184

---

What is the difference between a repository server and a powerhouse?

1515

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2428

---

What do you mean by enterprise data warehousing?

1068

---

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

1867

---

What does “tail –f” command do and what is its use as an Informatica admin.

1113

---

explain about unit testing? in real time?

2210

---

Define mapplet?

1018

---

Mention a few design and development best practices for informatica?

1002

---

Define Pmrep command?

1070

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2749

---

What is confirmed fact in dataware housing?

6978

---

EXL informatica Questions

1396

---