What is Factless fact table ???
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / dev
A Fact table without numeric fact column is called factless
face.
Is This Answer Correct ? | 14 Yes | 2 No |
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 |
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 |
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 |
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 |
Answer / balu
A fact table without Numeric data is called factless fact
table
Is This Answer Correct ? | 1 Yes | 1 No |
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 |
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
What is the difference between bitmap and btree index?
what is normalizer transformation?
What are the different tools in workflow manager?
In a sequential batch can you run the session if previous session fails?
TELL ME ABOUT WORK FLOW SCHEDULING?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
HOW TO DELETE A RECORD FROM FLAT FILE
Why we select the table which has minimum number of records as Master table in joiner?
What are ETL Tools?