Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact table?
- 9 Answers
- 13608 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gp
The table contain measurable data(facts) is called fact
table .
These facts defined three types : Additive
Non Additive
Semi additive facts
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / m.sivakumar
The centralized in a star schema is called fact table.
fact table have two types of columns.
facts
foreign keys to dimension tables.
fact tables are three types
1)additive
2)non-additive
3)semi additive
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / honey
A central table in a data warehouse schema that contains
numerical measures and keys relating facts to dimension
tables. Fact tables contain data that describes specific
events within a business, such as bank transactions or
product sales.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / p.suneetha roy
A central table in a data warehouse schema that contains
numerical measures and keys relating facts to dimension
tables as primary key present in Fact table for the
uniqueness and foriegn keys coming from dimension tables
referring to fact table. Fact tables contain texture data
and section.
There are 4 types of facts :
1)Additive
2)Non Additive
3)Semi additive facts
4)Factless fact.
Let me know if there are any more facts.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / bhargavi
Fact table contains facts or measurements(numeric values)
of the business
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / suren
Fact table contains measurement of information
Factless table contians with out any measure.
1.Additive : Additive fact table contains the summarized
data.
2.Non Additive : Non Additive fact table contains without
additve data.it contains only detail data
3.SemidAdditive: Semi additive fact table contains both the
summarized data as well as detial data
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shyam
Dimension table contains the textual information to analyse
the business. It contains more number of column as compare
the less no. of rows.
There are the four types of dimention table in the
Datawarehousing.
1. Confirmed Dimension
2. Shared Dimension
3. Degenerated Dimension
4. Jun Dimension.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / amit
fact table is collection of all facts in the dimension
facys is nothing but quantitative data
| Is This Answer Correct ? | 3 Yes | 8 No |
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
can a port in expression transf be given the name DISTINCT
what are the real time problems generally come up while doing or running mapping or any transformation?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
Mention few power centre client applications with their basic purpose?
Differentiate between Load Manager and DTM?
why we use source qualifier transformation?
Differentiate between a database and data warehouse?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
COM components can be used in Informatica
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
What is persistent lookup cache?
Teradata 
