Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 3 Answers
- 10617 Views
- Cap Gemini, Puma, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many dimensions are there in informatica?
What is a stored procedure transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to go to the older version for a mapping?
What are the designer tools for creating transformations?
What all are steps in up gradation of Informatica server?
Explain target update override in informatica
Design time, run time. If you don't create parameter what will happen
What is an expression transformation?
Explain the mapping variable usage example in informatica
What is dimensional table?
What do you mean incremental aggregation?
How can informatica be used for an organization?
What is blocking transformation?
How many number of sessions can one group in batches?
