can a fact table contains textual information
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 |
Define Routines and their types?
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
Thanks to all people who are posting their comments...
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
Explain the importance of surrogate key in data warehousing?
can we use sequential file as a lookup
What are system variables and sequencers in datastage
What are the partitioning techniques available in link partitioner?
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
when we have to go for a sequential file stage & for a dataset in datastage?
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
With out using Funnel Stage, how to populate the data from different sources to single target