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
- 10630 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 |
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
how to import multiple flat files in to single target where there is no common column in the flat files
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
What is a unit Testing?
What is the use of source qualifier?
What is polling?
What is aggregate cache in aggregator transforamtion?
how to load rows into fact table in data warehouse
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
checkout and checkin in informatica 8.6
Teradata 
