Answer Posted / rajkumar bachu

A Fact table without measures(numeric data) for a column is
called Factless Fact table.

eg: Promotion Fact(only key value available in FT)

Explain the shared cache and re-cache?

1120

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554

---

Repository user profiles

1764

---

Can we create two repositories on same database instance in oracle?

1095

---

How can we use batches?

1025

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1091

---

How to open an older version of an object in the workspace?

1207

---

What is the use of source qualifier?

1138

---

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

1864

---

Explain incremental aggregation in informatica

1131

---

Describe an informatica powercenter?

1127

---

what is Active lock explain

2800

---

What is repository manager?

990

---

What do you mean by filter transformation?

953

---