Interested to Buy Any Domain ? << Click Here >> for more details...
can a fact table contains textual information
- 6 Answers
- 14080 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 |
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
How can u write exception handling in seq file????
What is the use of datastage director?
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? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
what is a nodemap constraint
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
What is the function in Transformer stage can act as Rank Function in oracle
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
How rejected rows are managed in datastage?
Teradata 
