Can any one give me an example for factless fact table ?
If your answer is studunt attendence registration,could you
plese give me explanation for this ?

Answer Posted / sridhar

factless fact table is a fact table but table does n't have
any facts for measurement for e.g student attendance in a
class, if we have 100 members in a class we can perform the
calculations like marks,grades but you cannot measure for
student attendance.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1590


What is a stored procedure transformation?

610


What is InformaticaPowerCenter?

681


what is $$$$?

1736


Design a mapping to load the cumulative sum of salaries of employees into target table?

891






What does “tail –f” command do and what is its use as an Informatica admin.

629


What are the databases that informatica can connect to windows?

577


Explain the types of transformations?

596


What is repository manager?

534


Explain incremental aggregation in informatica

652


How do you promote a non-reusable transformation to reusable transformation?

658


What is the reusable transformation?

625


What all join we can perform in LOOKUP transformation?

562


How to update source definition?

628


What is decode in static cache?

586