Interested to Buy Any Domain ? << Click Here >> for more details...
can a fact table contains textual information
- 6 Answers
- 14286 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 |
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
what is 'reconsideration error' and how can i respond to this error and how to debug this
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
What is exact difference between Parallel Jobs and server Jobs..
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
To see hidden files in LINIX?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
what is datastage job Monitoring
How we can convert rows to columns in datastage?
What are the different layers in the information server architecture?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Teradata 
