can a fact table contains textual information

Answers were Sorted based on User's Feedback



can a fact table contains textual information..

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

can a fact table contains textual information..

Answer / kiran

In a factless fact table we can have "textual information".

Is This Answer Correct ?    5 Yes 3 No

can a fact table contains textual information..

Answer / reddymkl.dwh

NO, Junk dimension have textual information.

Is This Answer Correct ?    1 Yes 0 No

can a fact table contains textual information..

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

can a fact table contains textual information..

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

can a fact table contains textual information..

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

Post New Answer

More Data Stage Interview Questions

Define Routines and their types?

0 Answers  


SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 Answers  


Thanks to all people who are posting their comments...

1 Answers   CTS,


WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?

2 Answers   GE,


Explain the importance of surrogate key in data warehousing?

0 Answers  






can we use sequential file as a lookup

7 Answers   Cognizant, Wipro,


What are system variables and sequencers in datastage

0 Answers  


What are the partitioning techniques available in link partitioner?

0 Answers  


How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.

5 Answers  


when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  


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

6 Answers  


With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,


Categories