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 ?
Answers were Sorted based on User's Feedback
Answer / jaspreet banga
Practical senario would be in a bank where you want to list
the customer information(customer dimension), Branch
information (Branch Dimension),Joining date (Date
Dimension) and the scheme (loan or deposit or current
account) they have taken in the Bank. So the Fact less fact
table would be Branch Key,Customer Key, Date Key, Account
Key (or Product or scheme Key).These all are foriegn key,
The balance you have is the fact which may or may not be
there, i.e., if you have null balance then it is fact less
fact tables
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / 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 |
Answer / 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 ? | 1 Yes | 0 No |
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
how to connect two or more table with single source qualifier?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How might you approve all mappings in the archive all the while?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Does Facttable Normalized or Denormalized?
What is xml source qualifier transformation in informatica?
Explain the flow of data in Iinformatica?
What is the need of building a data warehouse?
In real time scenario where can we use mapping parameters and variables?
What is informatica powercenter repository?
What are the new features of informatica 9.x at the developer level?