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 the Process to creating lookup transformation in informatica
What will be the approach?
what is the process of target load planing?
Discuss the advantages & Disadvantages of star & snowflake schema?
What is the way to execute pl/sql script using informatica mapping?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
If you want to create indexes after the load process which transformation you choose?
Hi experts, can anyone tell how much we use plsql in real time
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
how will compare two mappings in two different repository?