Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is fact table?

Answers were Sorted based on User's Feedback



what is fact table?..

Answer / 24/12/2007

it contains only measurable values or datas

Is This Answer Correct ?    9 Yes 5 No

what is fact table?..

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

what is fact table?..

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

what is fact table?..

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

what is fact table?..

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

what is fact table?..

Answer / bhargavi

Fact table contains facts or measurements(numeric values)
of the business

Is This Answer Correct ?    2 Yes 0 No

what is fact table?..

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

what is fact table?..

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

what is fact table?..

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

Post New Answer



More Informatica Interview Questions

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,


I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,


what is song in infrmatica...?

0 Answers   CTS,


How to load last n records of file into target table - informatica

0 Answers   Informatica,


i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  






What is surrogate key?

9 Answers  


1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,


Mapplets can you use an active transformation in a mapplet,

1 Answers  


Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,


in static and dynamic which one is better

2 Answers  


what is the incremental agrrigation?

2 Answers   Cap Gemini,


How are indexes created after completing the load process?

0 Answers  






Categories