can a fact table contains textual information
Answer Posted / 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 |
Post New Answer View All Answers
how to abort the job its matain duplicates?
What is the difference between datastage and informatica?
Give an idea of system variables.
Describe the main features of datastage?
How can one find bugs in job sequence?
Can you explain repository tables in datastage?
What is a datastage job?
To see hidden files in LINIX?
Define APT_CONFIG in Datastage?
options available in sequence job to run,validate?
What is the difference between operational data stage (ods) and data warehouse?
How do you reject records in a transformer?
what are the devoleper roles in real time? plz tell i am new to datastage....
How to reverse the string using SQL?
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?