What is Factless fact table ???

Answers were Sorted based on User's Feedback



What is Factless fact table ???..

Answer / rajkumar bachu

A Fact table without measures(numeric data) for a column is
called Factless Fact table.

eg: Promotion Fact(only key value available in FT)

Is This Answer Correct ?    46 Yes 4 No

What is Factless fact table ???..

Answer / tadikonda

FACT TABLE CONTAINS ONLY ID,KEYS AND DESCRIPTION COLUMNS AND
NOT MEASURES ARE KNOWN AS FACTLEES FACT TABLES

Is This Answer Correct ?    33 Yes 4 No

What is Factless fact table ???..

Answer / dev

A Fact table without numeric fact column is called factless
face.

Is This Answer Correct ?    14 Yes 2 No

What is Factless fact table ???..

Answer / praveen

fact less fact table is nothing but.......
Fact table consists only s.k's nothing other than sk's...

Example::
Students Attendtance... It consists only student
information nothing other than present or absent..i.e
Boolean values(Yes or No)

Is This Answer Correct ?    18 Yes 9 No

What is Factless fact table ???..

Answer / jagan

A Factless fact table captures the many-to-many
relationships between dimensions,but contains no numeric or
textual facts.

Is This Answer Correct ?    8 Yes 1 No

What is Factless fact table ???..

Answer / praveen

A Fact table without numeric fact column is called factless
face.
(OR)
fact table contains only id.keys and description columns
and not measures are known as factless fact table.

Is This Answer Correct ?    6 Yes 1 No

What is Factless fact table ???..

Answer / m.mahendra

The fact table which contains the business events or
coverage that could be represented in a fact table, but
there will be no measures or facts associated with these.

Is This Answer Correct ?    5 Yes 5 No

What is Factless fact table ???..

Answer / bbb

No measure

Is This Answer Correct ?    3 Yes 3 No

What is Factless fact table ???..

Answer / balu

A fact table without Numeric data is called factless fact
table

Is This Answer Correct ?    1 Yes 1 No

What is Factless fact table ???..

Answer / aneesh

A factless fact table is fact table that does not contain
fact.They contain only dimesional keys and it captures
events that happen only at information level but not
included in the calculations level.just an information about
an event that happen over a period.
Refer the below site to get a better idea

dwhlaureate.blogspot.in/2012/08/factless-fact-table.html

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,


In which scenario did you used pushdown optimization?

1 Answers  


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,


What is decode in informatica?

0 Answers  


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,






What do you mean by worklet?

0 Answers  


Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,


What are the different types of Type2 dimension maping?

2 Answers   CTS,


How many ways you create ports?

1 Answers  


Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,


what is the size of your data warehousing?

0 Answers   IBM,


How to generate sequence numbers?

0 Answers  


Categories