Answer Posted / arun

A dimension which have frequent changes. These type of dimensions can be maintained by splitting up the frequently changing attributes in to sub dimensions (More like a Normalized structure), so history can be maintained with less storage. But retrieval may be time consuming.

Explain dynamic target flat file name generation in informatica

1021

---

Can anyone tell me the new features in Informatica 9 Version?

2060

---

What is a rank transform?

1050

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1136

---

Explain what are the different versions of informatica?

1055

---

Explain lookup transformation source types in informatica

1060

---

What is repository manager?

950

---

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

1823

---

Define mapplet?

981

---

Explain the tuning lookup transformation - informatica

968

---

how to load dimension table and fact table. plz tell me the steps.

2058

---

Repository user profiles

1726

---

Describe the impact of several join conditions and join order in a joiner transformation?

1023

---

Explain transaction control transformation in informatica

1229

---

Can you use flat files in Mapplets.

2623

---