Interested to Buy Any Domain ? << Click Here >> for more details...
can a fact table contains textual information
- 6 Answers
- 14277 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 |
How do you start developing a datastage project?
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
Where do you see different stages in the designer?
How many types of stage?
Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
what is the main differences between Lookup, Join and Merge stages?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
What is meta stage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?
Teradata 
