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
- 10734 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
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is the Rank index port in Rank transformation?
Where can we find the throughput option in informatica?
What is a rank transform?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
whats the logic to load the lower level of granularity of data to fact table.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is update strategy transform?
What all join we can perform in LOOKUP transformation?
What you know about transaction control transformation?
generate date / time dimension in informatica
What is the procedure for creating independent data marts from informatica 7.1?
What is meant by query override?
How to load a Dimension ? and how to load a fact table?
What are the components of the workflow manager?
