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
- 10552 Views
- Cap Gemini, Puma, Wipro, I also Faced
- E-Mail Answers
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 function of look up transformation?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
Can we run session without using workflows?
Why you use repository connectivity?
what are the difference between Informatica 7.1 and 8.1?
what is fact table?
without dynamic lookup transformation how to insert new rows and update existing rows?
Explain pushdown optimization and types in informatica
why we use stored procedure transformation?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
Explain sessions and how many types of sessions are there?
How many repositories can we create in Informatica?
Teradata 
