Interested to Buy Any Domain ? << Click Here >> for more details...
What is Factless fact table ???
- 12 Answers
- 44723 Views
- Satyam, Tech Mahindra, I also Faced
- E-Mail Answers
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 |
In dimension and fact table? which one holds big data?
Why we use ENABLE HIGH PRECISION in session properties?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
what is the drillup & drill down?and use of the drill up and drill down?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
What can we do to improve the performance of informatica aggregator transformation?
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
What are Dimensional table?
What are session parameters ? How do you set them?
How to configure mapping in informatica?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
How to load last 10 records of flat file in to the target?
Teradata 
