Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact table?
- 9 Answers
- 13357 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 |
how to load only the first and last record of a flat file into the target?
Mention some types of transformation?
what is surrogate id ?
Differentiate between Load Manager and DTM?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
What is the command used to run a batch?
what are the row and column separations in Flat Files
can you avoid static cache in the lookup transformation? I mean can you
State the limitations where we cannot use joiner in the mapping pipeline?
How to create the source and target database connections in server manager?
what is the difference between mapplet & stored procedure?
Which version configuration tool used in ur project?
Teradata 
