Answer Posted / chandrasekar

A Fact table contains unique combination of dimensional keys.
Fact tables are normalized.
A Fact tables have the facts at the lowest level of granularity.

Types of Fact table:
There are 3 types .
1)Detailed Fact table
2)Aggregate/Summarize fact table
3)Factless fact table

If it wrong means please send the correct answer to me
chandranmca2007@gmail.com

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2293

---

What is Cognos script editor?

4290

---

In warehouses how many schemas are there?

1131

---

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

1265

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2170

---

can u give example for factless fact table

6783

---

What is a surrogate key?

1157

---

What is the cumulative sum and moving sum?

1236

---

How to generate sequence numbers?

1136

---

How do you load alternate records into different tables through mapping flow?

1928

---

What is lookup transformation?

1094

---

What do you mean by channel change?

1108

---

Explain the tuning lookup transformation - informatica

1047

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1733

---

How do you convert single row from source into three rows into target?

1216

---