Interested to Buy Any Domain ? << Click Here >> for more details...
What is Factless fact table ???
- 12 Answers
- 45293 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 |
What are Dimensions and various types of Dimensions?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is surrogate key?
Difference between Target-based loading and constraint-based loading?
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
How do you load unique records into one target table and duplicate records into a different target table?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15
Briefly define a session task?
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
Teradata 
