Answer Posted / arasu
example for junk dimension:
consider a trade company which consists of fact about trading that take places in a share trading firm.in these there may be some facts like mode of trade(which indicates whether the user is trading through phone or online)which will be not related to any of the dimensions such as account,date,indices,amount of share etc.
so these unrelated facts are removed from the fact table and stored as a separate dimension as a junk dimension which will be useful to provide extra information
| Is This Answer Correct ? | 30 Yes | 1 No |
Post New Answer View All Answers
if you use oracle sql*loader , how do you transform data with it during loading?
Why should you put your data warehouse on a different system than your oltp system?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Is there any difference in testing database and data ware housing?
Explain what is the difference between a primary and secondary actor in use case modeling?
How to create prompts in report net?
What is freehand sql?
What is bi?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What is the difference between connected and unconnected stored procedures?
What is a fact, dimension, measure?
Explain what is type 2 version dimension?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
How to eliminate duplicate rows from flat file?
