what is fact table?
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 mystery dimension?
What is the difference between a connected look up and unconnected lookup?
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
What are the different types of Type2 dimension maping?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What will be the approach?
How do you join more than 3 flat files in informatica?
What are the components of workflow manager?
Mention few advantages of router transformation over filter transformation.
What is a data modeling?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.