Answer / siva

Fact table contains facts,measures or numerical vlues. Foe
example if your business process is 'sales' then a
measurment of this business process contains name of the
product,price of product,location and date and time of the
product sales.It also contains foreign keys of all the
dimension tables.

Answer / rekha

Fact table is the primary table in the dimensional
modeling . the numerical performance of measures of the
business stored in fact table
mostly used facts ara numeric and additive
not every numeric is a fact ,but a numeric wich ara of type
key performance indicator is called fact

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

---

what is lookupoverriding?

1 Answers  

---

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

---

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  

---

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

---