Interested to Buy Any Domain ? << Click Here >> for more details...
can a fact table contains textual information
- 6 Answers
- 14431 Views
- HCL, HCL BSERV, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / phani kumar
NO.As a Fact table, it contains foreign keys for maintaining
relationships and measures for analyzing the business as
year/half-year/quarter wise.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / kiran
In a factless fact table we can have "textual information".
| Is This Answer Correct ? | 5 Yes | 3 No |
NO, Junk dimension have textual information.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / venkat
Hai phani Kumar,
your answer is wrong
Fact table stores Multi part keys,KPI,Meassures
...
U r saying fcatlessfcat table
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sreeni
fact table contains 2 segment dimension keys with measurements
if contains numeric values of what u mesure
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the situation where you have applied SCD in your project?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
How to remove blank spaces from data?
how do u catch bad rows from OCI stage? And what CLI stands for?
how to transfer file from one system to another system in unix? which cmd to be use?
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
wt is the diff b/w odbc and oracle stage
What is the difference between validate and compile?
Pls tell me what is troubleshooting in datastage view?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
Teradata 
