Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact table?
- 9 Answers
- 13864 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 Join Tables my Source is having 15 table target is one?
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
What is lookup change?
write a query to retrieve the latest records from the table sorted by version(scd)
in which situations do u go for scds ?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
what is degenerated dimension table with scenario
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
What is the capacity of power cube?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
What does reusable transformation mean?
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
Teradata 
