Interested to Buy Any Domain ? << Click Here >> for more details...
What is Factless fact table ???
- 12 Answers
- 45643 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 |
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
1 lac of flat fles in source how to load target at a time?
How to generate the HTML output using Informatica.
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
tell me the rules and responsblites in our project(my project is development)
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
what is fact table?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
Which will beter perform IIf or decode?
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
Teradata 
