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
In Datastage, how you can fix the truncated data error?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
how to export or import the jobs in .ISX file
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How to clean the datastage repository?
How to find value from a column in a dataset?
How to convert RGB Value to Hexadecimal values in datastage?
What is datastage engine?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the areas of application?
How to Remove Duplicate using SQL?
how do u catch bad rows from OCI stage? And what CLI stands for?
How do you run datastage job from the command line?
which r the connectors used in san?
What is use Array size in datastage