can a fact table contains textual information
Answer Posted / rajesh
ANS: We can put textual information but not useful, actually
in FACT table, in contains numeric value for calculating
measurement like sales, profit/loss, revenue, date/time,
production, stock etc. in Fact table, it contains foreign
keys for maintaining relationships and measures for
analyzing the business as week/ month/quarter/year etc.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between datastage and informatica?
What is the difference between Datastage 7.5 and 7.0?
What is data partitioning?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Where do you see different stages in the designer?
Lookup constraints
how many rows sorted in sort stage by default in server jobs
What is the difference between hashfile and sequential file?
What is the roundrobin collector?
What is job control?
Define Data Stage?
how can we create rank using datastage?what is the meaning of rank?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the enhancements made in datastage 7.5 compare with 7.0?
What is orabulk stage?